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.