date format in Excel 2003

S

sptpensions

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.
[email protected]
 
B

bj

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)?
 
D

Dave Peterson

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
 
D

Dave Peterson

Ps. Then reenter the date(s).
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.
[email protected]
Click to expand...
 
S

sptpensions

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

S.
 
Top