relatively simple date formatting

  • Thread starter Thread starter ED
  • Start date Start date
E

ED

Hello

I have a column filled with dates such as

20030831
20030913
20031011
20031126

These were imported from an Access database, and were text at the time. I
changed the cells to be date, but can get them to translate into date
formats as

Aug-31-2003
Sep-13-2003
Oct-11-2003
Nov-26-2003

Thanks for any help
 
Select the column, do data>text to column, click next twice, under column
data format select date, and from
dropdown select YMD and click finish.
 
Ed

One method

Select the cells. Data>Text to Columns>Next>Next. Check option button "date"
and set for YMD. Finish.

Format as you wish to be shown.

Gord Dibben XL2002
 
Back
Top