How to format a date in Calc?

0

When I enter 09/02/2013 00:00:00 in a cell in Windows 7, the cell displays 02.09.2013 00:00.

I have specified the proper Format code in Format Cells:

screenshot

In Windows XP, the outcome is as expected. The input 09/02/2013 00:00:00 gets displayed as 09.02.2013 00:00.

How to can fix this?

user1527484

Posted 2013-02-05T09:43:33.213

Reputation: 3

here is image from format cells http://i.stack.imgur.com/Ifq96.png

– user1527484 – 2013-02-05T09:44:04.807

It sounds like your global system date format on the Windows 7 PC is US format (MM/DD/YYYY) rather than European (DD/MM/YYYY) so when you enter the formula, it "looks" OK but is in fact wrong. If you attempt to enter "21/07/2013", what happens? – PJC – 2013-02-05T09:48:29.083

i changed format in Regional and Language Options and looks like its working now :) – user1527484 – 2013-02-05T10:07:07.040

If @PJC doesn't add an answer, you can answer your own question explaining how you solved your problem. To mark your question as solved you can accept that answer. We don't add [Solved] to the question title here. – Dennis – 2013-02-05T11:44:07.953

Answers

0

From what I'm seeing (and as per my comment), changing the global system date format (which controls how all applications accept dates) from US (MM/DD/YYYY) to EU (DD/MM/YYYY) should be the solution.

As you found, this is set in "Regional and Language Options".

PJC

Posted 2013-02-05T09:43:33.213

Reputation: 1 174

Asked: 2013-02-05T09:43:33.213

Viewed: 226 times

Active: 2013-02-05T13:26:29.387