| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Covert Number to date
If you want to go the formula route as Bob suggested, here is a slightly
shorter alternative for you to consider... =--TEXT(H1,"0000-00-00") Rick "Newbee" wrote in message ... 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Covert Number to date
This worked perfectly!!!
"Rick Rothstein (MVP - VB)" wrote: If you want to go the formula route as Bob suggested, here is a slightly shorter alternative for you to consider... =--TEXT(H1,"0000-00-00") Rick "Newbee" wrote in message ... 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 |
| Reply |
| 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) | |||
![Rick Rothstein \(MVP - VB\)[_440_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
