Apache OpenOffice Community Forum

Hi,
Am experiencing an annoying thing on a spreadsheet I'm doing some work on, every time I put a date in a column it is coming out wrong as an example I did some work earlier today Wednesday October 3rd 2017 but I noticed that despite putting the correct date in the column it is coming up as Friday 10th March 2017, I have checked all my settings that I can find and they show October 3rd 2017, this is a new computer to me with win 10

Any thoughts?

TIA

To what Locale is your OpenOffice set? You probably should use en-GB or some other European locale that reads DD/MM/YY; Today's date being read as 10 Mar 2017 suggests it is set to US locale.

More specifically, check the various settings in Tools | Options | Language Settings | Languages.

Tools>Options>LanguageSettings>Languages>Locale

(The issue isn't just about date formats, but also about date recognition, and basically about the relation between both these aspects.)

To regard the global 'Language Settings' for the spreadsheet document may not be sufficient.
See attached example.

And: Never use the globally deprecated "mid-endian" date formats of 'English (USA)' locale. They are really too bad and cause misunderstandings again and again. Use ISO 8601 compliant YYYY-MM-DD for display in spreadsheets and (in text form) for international exchange. To enter dates you may use whatever your software accepts. I needn't know, and I don't mind.

(This forum's software also should,)