Date Formatting

[MichaelR]

Hi,

I'm trying to format a system generated file to be more user friendly. The
file outputs dates like this: 20080714. Is there any way that I can change
the format to 07/14/2008 through a macro or a worksheet formula? I tried to
format the cells as dates but it didn't work.

Any ideas would be greatly appreciated.

Thanks!
Michael

 

[Max]

Try Data > Text to Columns, it's easiest
Select just the col of "dates". Click Data > Text to Columns. Click
Next>Next. In step3, under "Col data format": Check "Date", choose: "YMD"
from the droplist, click Finish

 

[Tim879]

try this...
=+DATE(LEFT(a1,4),MID(a1,5,2),RIGHT(a1,2))

 

[Gary''s Student]

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) and format as a date

 

[JE McGimpsey]

You could do it through either a macro or a workbook formula, but this
is easier:

Select your column of dates. Choose Data/Text to Columns. Click Next,
Next. Choose YMD in the Date dropdown, click Finish.

Format the column as you wish.