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

Try Data Text to Columns, it's easiest
Select just the col of "dates". Click Data Text to Columns. Click
NextNext. In step3, under "Col data format": Check "Date", choose: "YMD"
from the droplist, click Finish
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MichaelR" wrote:
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

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


On Jun 23, 10:20*am, MichaelR
wrote:
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

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) and format as a date
--
Gary''s Student - gsnu200793


"MichaelR" wrote:

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

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.

In article ,
MichaelR wrote:

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