| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Accidentally converted date mm/dd/yy to a 5 digit number
Somehow I accidentally hit a key(s) and caused my dates in one column of my
worksheet to convert to corresponding 5 digit numbers. Each date has its own unique number (i.e. 7/1/2005 now reads 38534). I want to change it back so that is actually displays the dates. How do I do that? I'm using MS Office Excel 2003 running on XP. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Numbers Converted to Text - Last Digit Replaced by Zero | Excel Worksheet Functions | |||
| How do i format a 5 to 6 digit number into the correct date? | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| On an import to excel a two digit date still is not right after c. | Excel Discussion (Misc queries) | |||
Threaded Mode
