Calendar dates

Discuss the spreadsheet application

Calendar dates

Postby JJJoseph » Thu Dec 13, 2007 3:34 am

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
JJJoseph
 
Posts: 173
Joined: Thu Dec 13, 2007 2:55 am
Location: Vancouver, Canada

Re: Calendar dates

Postby h1h » Thu Dec 13, 2007 10:19 pm

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
User avatar
h1h
 
Posts: 40
Joined: Wed Nov 28, 2007 8:45 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 21 guests