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?

4
  • here is image from format cells i.stack.imgur.com/Ifq96.png Feb 5, 2013 at 9:44
  • 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
    Feb 5, 2013 at 9:48
  • i changed format in Regional and Language Options and looks like its working now :) Feb 5, 2013 at 10:07
  • 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
    Feb 5, 2013 at 11:44

1 Answer 1

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".

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .