Calendar dates

Discuss the spreadsheet application
Post Reply
JJJoseph
Posts: 173
Joined: Thu Dec 13, 2007 2:55 am
Location: Vancouver, Canada

Calendar dates

Post 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.
OOo 3.4.X on MS Windows 7 + Blackberry 10
User avatar
h1h
Posts: 40
Joined: Wed Nov 28, 2007 8:45 pm

Re: Calendar dates

Post 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.
OOo 2.4 (from OOo-site) on Linux
Post Reply