date format in Excel 2003
 

When I am entering date as 08/20/2007, the return is "01/01/1900."
Previous cells in my workbook are fine, it is just the new ones come in this
way.

First I chose date, format, then 3/14/01 and the result is the same
"01/01/1900"
Next I went to custom and chose mm/dd/yyyy;;; with the same result.

How do I get the correct format??

Thanks,

Steve T.

date format in Excel 2003
 

when you format the cell as general do you get a '1'
(most problems would have ended up with 01/00/1900)
what do you get when you enter = date(2007,8,20)?

"sptpensions" wrote:

When I am entering date as 08/20/2007, the return is "01/01/1900."
Previous cells in my workbook are fine, it is just the new ones come in this
way.

First I chose date, format, then 3/14/01 and the result is the same
"01/01/1900"
Next I went to custom and chose mm/dd/yyyy;;; with the same result.

How do I get the correct format??

Thanks,

Steve T.

date format in Excel 2003
 

Try:
Tools|Options|transition tab
Uncheck all those Lotus 123 settings.

With those settings (transition formula entry), excel is behaving like 123 and
seeing:
08/20/2007
as
8 divided by 20 divided by 2007


sptpensions wrote:

When I am entering date as 08/20/2007, the return is "01/01/1900."
Previous cells in my workbook are fine, it is just the new ones come in this
way.

First I chose date, format, then 3/14/01 and the result is the same
"01/01/1900"
Next I went to custom and chose mm/dd/yyyy;;; with the same result.

How do I get the correct format??

Thanks,

Steve T.


--

Dave Peterson

date format in Excel 2003
 

Ps. Then reenter the date(s).

sptpensions wrote:

When I am entering date as 08/20/2007, the return is "01/01/1900."
Previous cells in my workbook are fine, it is just the new ones come in this
way.

First I chose date, format, then 3/14/01 and the result is the same
"01/01/1900"
Next I went to custom and chose mm/dd/yyyy;;; with the same result.

How do I get the correct format??

Thanks,

Steve T.


--

Dave Peterson

date format in Excel 2003
 

Yes, that was it, I was having Excel use it as a formula.
Thank you very much.

S.

"Dave Peterson" wrote:

Try:
Tools|Options|transition tab
Uncheck all those Lotus 123 settings.

With those settings (transition formula entry), excel is behaving like 123 and
seeing:
08/20/2007
as
8 divided by 20 divided by 2007


sptpensions wrote:

When I am entering date as 08/20/2007, the return is "01/01/1900."
Previous cells in my workbook are fine, it is just the new ones come in this
way.

First I chose date, format, then 3/14/01 and the result is the same
"01/01/1900"
Next I went to custom and chose mm/dd/yyyy;;; with the same result.

How do I get the correct format??

Thanks,

Steve T.


--

Dave Peterson