Date format

  • Thread starter Thread starter Bankboy
  • Start date Start date
B

Bankboy

I import external data from a text file downloaded from an antiquate
database with the result that the date format is as follows:

20041106

How can I convert this date to read:

06/11/2004

without having to manually change each one, which could run int
thousands of values.


Thanks
 
One way, select the column with the dates, do data>text to columns,
click next twice and under column data format select Date and
either YDM or YMD (depending on if the 06/11/2004 means June 11th 2004 or
if it means November 6th 2004, most likely the former so use YDM)
then click finish

--

Regards,

Peo Sjoblom

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