reformat numbers to dates

can vba be written to reformat date columns to date format: mm/dd/yy. my report returns the date as 1130809 (the first "1" is just an extra number in the report)
columna A & B.

Consider if A1 had the value 1130809 and I will store the result in the A2 Cell

Below is the code for you requirement

Please Login or Register  to view this content.

______________________________________________________________________________________________________________________________________
if you feel something has helped please click *

“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison