macro help for dates

[Aaron Russell]

I have two questions. I have a worksheet that has column A populated with
dates in the format of "yyyymmdd". Is there a macro that I can run that
will convert only the records in that column with data into the format of
say August 5, 2004.

Secondly is there a way I can insert a blank line with a macro if say A23
does not equal A24. Thank you.

 

[Ron Rosenfeld]

I have two questions. I have a worksheet that has column A populated with
dates in the format of "yyyymmdd". Is there a macro that I can run that
will convert only the records in that column with data into the format of
say August 5, 2004.

Secondly is there a way I can insert a blank line with a macro if say A23
does not equal A24. Thank you.

Have you tried Data/Text to Columns using ymd as the type of date?


--ron