| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you convert a number into a date
I have a file that was sent to me with a column of dates that appear like
20070602. I need it to look like 06/02/2007. I have tried to format it but I get ########### and the screen says something about a negative number. If I open a new blank worksheet and type it in 20070602, Excel automatically switches it to a proper date format. When I receive the file with the date as 20070602, it is already saved in excel. I have tried several different formats. Any help would be greatly appreciated. Thanks Jm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert number to date | Excel Discussion (Misc queries) | |||
| convert number to date format | Excel Discussion (Misc queries) | |||
| Convert Date to number? | Excel Worksheet Functions | |||
| How to convert date field to number value | New Users to Excel | |||
| How do I convert Date serial number to date | Excel Worksheet Functions | |||
Threaded Mode
