Dates 01/1/02005 comes u ps as 0.011111111

D

DateConfused

When I format for dates in a column I get this bogus number. How can I fix it
so the column reads the date entries?????
Thank you
 
D

Dave Peterson

Discounting the typo, maybe you have a Lotus 123 setting enabled.

Tools|Options|Transition Tab
Uncheck Transition Formula Entry

(I unchecked all those Lotus 123 settings.)
 
Top