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?
I tried using the Data\Text to Columns\and changed the text to a long date,
but it did not do it properly, it read the 60530 as 5/30/1960! Oh is there
code to automatically add 200 before the 60530. I added that and ran the Data
Text to Column and it converted properly.
Thanks