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

  • Thread starter Thread starter Laura
  • Start date Start date
L

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,
 
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)
 
Back
Top