Date Problems In Excel

December 14, 2010 at 23:24:31
Specs: Windows XP
Hey guys, I'm having a problem with Dates in Excel. When I use the When I set the date to be dd/mm/yyyy it automatically takes it as mm/dd/yyyy. The problem is that this doesn't happen in all rows, only in a few of them and they can not be changed when I from "Format Cells" -> "Dates".

Can anyone help??
Thank you

See More: Date Problems In Excel

Report •

December 14, 2010 at 23:31:39
Please note the following:

1: I think the problem is from my PC not from Microsoft Excel because I'm having the same problem in my Accounting Platform
2: If I want to say we're on the 1st of December, I have to type it as 12/01/10 and the Excel will understand it as 01/12/10. If I type 01/12/10, it will be filled as 12/01/10.

Thank you,

Report •

December 15, 2010 at 06:02:37
Check your computers Regional and Language Options and see how the system is setup.

Click Start
Click Control Panel
Click Regional and Language Options

Under the Regional Options Tab
See if your set up correctly for your area.


Report •

Related Solutions

Ask Question