Calendar dates
Calendar dates
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
Re: Calendar dates
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