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
--
Carolan

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

"CarolAn" wrote:

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
--
Carolan

The default date format is as per your regional date/time settings . Control
PanelRegional and language settingsRegional 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
---------------
Jacob Skaria


"CarolAn" wrote:

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
--
Carolan

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.
--
David Biddulph

"CarolAn" wrote in message
...
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
--
Carolan

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


"Jacob Skaria" wrote:

The default date format is as per your regional date/time settings . Control
PanelRegional and language settingsRegional 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
---------------
Jacob Skaria


"CarolAn" wrote:

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
--
Carolan

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.
--
David Biddulph

"Eduardo" wrote in message
...
Hi,
don't use culstom format select the cell, cell format and then select
date,
choose 14/03/01, it will work

"CarolAn" wrote:

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
--
Carolan