date format in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
(e-mail address removed)
 
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)?
 
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
 
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.
(e-mail address removed)
Click to expand...
 
Back
Top