On 21/12/2005 18:58, Terry North wrote:
Bob <baasha <at> shaw.ca> writes:
I have a column set up in Calc to format dates as MM/DD/YY. This
normally works fine. A couple of days ago I tried to enter two dates,
09/12/05 (Sep. 12th) and 10/12/05 (Oct. 12th). The program seems to
assume that because I am entering this information in December, then I
must mean Dec. 9th and Dec. 10th, which is not the case. I can not seem
to find a way to override this behaviour. Am I doing something wrong,
or is this a bug?
I take it the dates are displaying as 12/09/05 and 12/10/05 even though you
input 09/12/05 and 10/12/05. That is strange because the format DD/MM/YY
would still show your input as entered. If your cell formats are still
correct, perhaps you need to check language settings - Tools /Options
/Language Settings /Languages.
You haven't used any other formatting?
If you do not format the cells, the format you use seems to be the default
format. Perhaps you should put the matter beyond any doubt by selecting
English (USA) as the language when formatting the cells.
Thanks Terry,
That was it; a conflict between my locale setting and my date
formatting. I worked for an American corporation for many years, so I
got used to formatting dates in the American way. But I had my
spreadsheet set up for Canadian English, so it is no wonder the program
was confused. G.I.G.O. is just as true as it always has been. :-))
Bob
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
