relatively simple date formatting

[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

 

[Peo Sjoblom]

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.

 

[Gord Dibben]

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