Try tools|Options|transition tab.
Uncheck transition formula entry

Excel is behaving like Lotus 123 and seeing your entry as a division
(8 divided by 23 divided by 2005)

I'd uncheck all those Lotus options if I were you.

CycloneGD wrote:

i am using a modified excell sheet.
I enter a date in a cell (i.e.8/23/2005) but it shows up as 1/1/1900.
I have reformated the cell to a data format., but sit still doesn't take.
What is wrong???

--

Dave Peterson