Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert numbers to date in excel ex: 20070320 to 06/30/2007
I have a range of cells in excel that were exported from another software and
the data came out looking like the above example with dates in the format of numbers...ex from above 20070320 as a number in the cell and I need to know the easiest way to convert this to the date 3/20/2007 for the whole range. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert numbers to date in excel ex: 20070320 to 06/30/2007
select the cells, use Data/Text to Columns/ in step 3 of the wizard, you can
indicate it's a date, and then specify ymd format; then click finish. "mreedtigers" wrote in message ... I have a range of cells in excel that were exported from another software and the data came out looking like the above example with dates in the format of numbers...ex from above 20070320 as a number in the cell and I need to know the easiest way to convert this to the date 3/20/2007 for the whole range. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to convert Excel 2007 files to earlier versions? | Excel Discussion (Misc queries) | |||
need to convert wb3 files to excel 2007 | Excel Discussion (Misc queries) | |||
how will i convert 05.01.2007 convert 05.Jan.2007 format? | New Users to Excel | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
extract numbers, convert to date | Excel Discussion (Misc queries) |