| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates not showing up as dates
I have a file that was exported somehow from another program and some of my
dates are showing up as a negative number. ie...-620589, -617597. I believe that these dates were not entered with the correct year so when they were exported Excel did not read them correctly. Is there a way to tell what the dates should be so I can correct them? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| drop down list showing dates instead of numbers | Excel Discussion (Misc queries) | |||
| Summary sheet showing holiday dates taken | Excel Worksheet Functions | |||
| Dates showing are not what I type | New Users to Excel | |||
| Combo Box Showing numbers not dates | Excel Discussion (Misc queries) | |||
Threaded Mode
