Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
copy a sheet in same workbook temporary block excel | Excel Worksheet Functions | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |