Page 1 of 1

Calendar dates

Posted: Thu Dec 13, 2007 3:34 am
by JJJoseph
The default calendar date input format is wrong (in the input window) in my Calc (MM DD,YYYY). How can I change it to the ANSI format as in YYYY-MM-DD ? No matter what I do, it always reverts to the Windows date format, i.e MM DD,YYYY, which is confusing and leads to errors.

Re: Calendar dates

Posted: Thu Dec 13, 2007 10:19 pm
by h1h
the way dates are displayed is based on your system settings. In your case I assume the system setting US style. If you don't like that, then either change your system settings or format the cells with dates individually throu formt, Cells,Number Format.