| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Covert Number to date
I have a spreadsheet with 20071123 is in number format. I am trying to
covert it so that excel will see those numbers as a date. It is not text but in number format. How do I change this to make it read 11/23/2007 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Covert Data the comes for a CVS | Excel Discussion (Misc queries) | |||
| Covert string to date, etc | Excel Discussion (Misc queries) | |||
| covert 72.8 to 72:48 | Excel Worksheet Functions | |||
| How do I covert number format? | Excel Discussion (Misc queries) | |||
| How does excel automatically covert cells when a different number. | Excel Discussion (Misc queries) | |||
Threaded Mode
