Dates 01/1/02005 comes u ps as 0.011111111
 

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

umm

01/1/02005
isn't a date - any reason you have the extra 0 in before the 2005?

if this was a typo in your post then could you give us a couple of examples
of your dates, let us know how you entered them and how you're trying to
format them.

Cheers
JulieD

"DateConfused" wrote in message
...
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