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 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
