Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet that I am currently having problems with the date not
displaying correctly. I don't know what I did but when I first started the spreadsheet it was fine. If I type in a date such as 4/10/2004 is displays as 38087. If I want the date to display I have to type in '4/10/2004 for it to display in the cell. I need to be able to change back all of the dates that were converted to this numbering. If I go into format cells and click on date and choose the date display nothing happens as well as if I click on the general tab. I don't know what I did but, can anyone please help me? Thanks, Deb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Character/Symbols not displaying correctly in this web forum ??? | Excel Discussion (Misc queries) | |||
date and time | New Users to Excel | |||
Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) |