I entered 11/22/2004 in excel workbook and it keeps changing to ##
 

I was working on my mileage work sheet in excel for some reason when I
entered 11/22/04 it keeps changing to #######. What's this. If I click on
it the 11/22/2004 is shown, but when I go to another cell it changes back to
#######.
I don't know what I could do to show the date on ther worksheet as
11/22/2004/ Please help.

Widen the column

--

Regards,

Peo Sjoblom


"Firefly" wrote in message
...
I was working on my mileage work sheet in excel for some reason when I
entered 11/22/04 it keeps changing to #######. What's this. If I click
on
it the 11/22/2004 is shown, but when I go to another cell it changes back
to
#######.
I don't know what I could do to show the date on ther worksheet as
11/22/2004/ Please help.