macro help for dates

  • Thread starter Thread starter Aaron Russell
  • Start date Start date
A

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.
 
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.
Click to expand...

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


--ron
 
Back
Top