changing date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I download into Excel. The report has dates for many
months. The current date format is ymmdd (ie 60530) and I'd like to convert
it to an easier to read format like 05/30/06. Is there code that I can use
in an existing page setup macro to do this for all rows in the speadsheet?
Thanks
 
SITCFanTN said:
I have a report that I download into Excel. The report has dates for many
months. The current date format is ymmdd (ie 60530) and I'd like to
convert
it to an easier to read format like 05/30/06. Is there code that I can
use
in an existing page setup macro to do this for all rows in the speadsheet?
Thanks
Click to expand...
 
Hi

Try Data - Text to columns. There is an option - on the third page, I
think - to tell Excel that you have a date - and also its format.

Andy.
 
Thanks for your help Andy I learned something new, the only thing is that it
is reading 605030 as 5/30/1960.....I was thinking if there was a way to add
200 before the 6, maybe it would calculate better. Is there code I can use
to do that before I do the conversion that you know of. Thanks
 
Back
Top