Date format in Excel

alphabyte

alphabyte

Senior Member
Joined
Jun 17, 2008
Messages
520
Reaction score
130
Location
Pretoria
Hi, Please help me before I go completely nuts!
I have an Excel spreadsheet (Office 2010) in which one column is for dates. I have formatted the column to display the dates as 2012-02-06, this being for 6 February 2012. So far so good.
I have been used to entering the dates, for example, by simply typing the entry as 6-2 Enter. For some reason Excel now accepts this as 2 June instead of 6 February, and for the life of me I don't know why it has changed.
I've tried the date formatting, as well as the Regional and Language settings in Control Panel with no luck. Different spreadsheets - no luck. Google has also not helped.
Any suggestions?
 
You sure you got the regional settings right? Even under the additional settings page?

Sent from my GT-N7000 using Tapatalk
 
You can drive yourself nuts trying to work with dates in Excel sometimes.

As a double check, do you get the proper date (i.e. today) if you enter =now() in one of the formatted cells?
 
As a double check, do you get the proper date (i.e. today) if you enter =now() in one of the formatted cells?
Click to expand...
Yes, 7 February (today) appears in the cell as 2012-02-07 as it should...
 
I'm stumped on this one. If you do find a solution, please post here.

In the meantime, would there be any harm in just switching the order of your day & month when entering data?
 
Haven't yet found the solution for this one.
In the meantime, would there be any harm in just switching the order of your day & month when entering data?
Click to expand...
Okay, I guess I'll just have to get used to this; but it is annoying when I've been used to typing it the other way round, and I don't know why it has changed :(
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X