| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Covert Number to date
=DATE(LEFT(H1,4),MID(H1,5,2),RIGHT(H1,2))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Covert Number to date
Select the column with the "dates", do datatext to columns, click next
twice, under column data format select Date and from dropdown select YMD and click finish -- Regards, Peo Sjoblom "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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Covert Number to date
Try this:
Select the cell in question Goto the menu DataText to columns Click Next twice In Step 3 of the wizard under Column data format... Select DateYMD Click Finish -- Biff Microsoft Excel MVP "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 |
|
#5
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 |
|
#6
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) | |||
Linear Mode
