You have to use a date separator for Excel to know what you're entering.
Dates are in reality just serial numbers starting with 1/1/1900 as day 1.
Day 10305 is evidently 3/18/1928.

--
Jim Rech
Excel MVP
"sj" wrote in message
...
| enter date 010305 and the date changes to 3/18/28 very strange and can be
| repeated. Is there a fix for this? Running excel 2003, 11.6113.5703