DATE FORMAT NOT WORKING

[CarolAn]

I have cells with a date formated as mm/dd/yy, but when I enter the date in
changes it as follows - if I enter 09/08/09 (Sept 8/09) it changes it to
08/09/09. When I look at it in the formula it shows is correctly as
09/08/09. What am I doing wrong?
I'm using Excel2007

 

[Eduardo]

Hi,
don't use culstom format select the cell, cell format and then select date,
choose 14/03/01, it will work

 

[Jacob Skaria]

The default date format is as per your regional date/time settings . Control
Panel>Regional and language settings>Regional Options tab.

What I do to enter a date in excel is to enter Ctrl+semicolon and edit...

To know more about excel date and time refer the below from Chip
http://www.cpearson.com/excel/datetime.htm

If this post helps click Yes

 

[David Biddulph]

Check your Windows Regional Settings (in Control Panel).
It looks as if it is expecting input to be formatted as dd/mm/yyyy
Excel cell formatting governs how the *output* of a number is *displayed*;
the windows settings govern how the *input* is interpreted.
It is, of course, unambiguous if you use a format such as 8 Sep 2009.

 

[CarolAn]

Thank you. I didn't know that the regional setting for Canada was different
than the USA.

 

[David Biddulph]

But she doesn't want to see dd/mm/yyyy, she wants mm/dd/yyyy
Her problem is on the inputting of the data, not in the formatting of the
output.

 

[FatBytestard]

Thank you. I didn't know that the regional setting for Canada was different
than the USA.

Home of the CSA. Yes, Canada strives to differ in some places. UL
wasn't good enough.

CSA cert is a bitch to get on a product sometimes.