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" wrote in message
...
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

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.

"SITCFanTN" wrote in message
...
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

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

"AndyB" wrote:

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.

"SITCFanTN" wrote in message
...
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

Hi SITCFanTN,

See response in Programming.


---
Regards,
Norman


"SITCFanTN" wrote in message
...
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