how to convert number 20000321 into date 03/21/2000

[Laura]

Hi!
Does anyone know how to convert a column of numbers in the
form of yyyymmdd into a column of dates in the form of
mm/dd/yyyy either through some sort of quick copy and
paste or a macro or whatever? I have thousands of records
but I need the dates as dates and not just numbers.

thanks,

 

[Peo Sjoblom]

Select the column, do data>text to columns, click next twice, under column
data format, select YMD
and click finish

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Laura]

Thanks. You've saved me a ton of work and a major
headache.