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.
|