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