On Tue, 14 Jul 2009 00:13:43 -0500, Tamblyne <[email protected]> wrote:
>I've taken a break from trying to do these cemetery transcriptions in >a spreadsheet. The date formatting tricks worked great, but it was >too clunky otherwise. So I switched to a Writer using a table. There >was a bit of tweaking there, too, but it looks a lot better. > >So I have my table cells for the dates formatted "D MMM YYYY." All >night long, I've been typing 10/11/1901 and it reformats to 11 Oct >1901 -- just as I expect it to. If I type in only a year, it accepts >that just fine, but then the next row that has a full date in it, I >have to "re-set" the date formatting back to "D MMM YYYY" and it's >fine, again, until the next time I have only a year. No problem. It's >working fine, doing what I expect. > >Then, all of a sudden, I type "10/11/1901" and I start getting "10 Nov >1901" instead of "11 Oct 1901." I check my date formatting, and it's >still the way it's supposed to be -- but I reset it anyway. No good. >*Now* I'm getting "10/11/01" when I type "10/11/1901" -- even though >the date format is still showing as "D MMM YYYY" :-/ If I type "10 >Oct 1901" it's switching it to "10/10/01" ARGH! > >I have no idea what I'm doing to trigger these surprises and >inconsistancies (v.3.1.0). I'm doing the same thing all the time, but >never know when different results are going to show up. I'm recalling >now that this is why I didn't use OOo to do these transcripts way back >with v.2 -- so it's not a new problem with v.3. I've had to shut down >and restart v.3 a lot for some reason, but that doesn't seem to help >this particular problem. > >I tried one more thing before sending this -- I deleted my >user-defined format code and entered it again -- and now it's working >again. Does anyone have any idea what I did to make it stop working >in the first place? > >Tam Well, that didn't last long -- two more rows and it's reversing the month and the day again. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
