code to convert date from TEXT format (03-02) to DATE format (200203)
 

Hi there - i'm hoping to get assistance with converting the following date
format to: yyyymm using vba...
the worksheet already contains some macros, so i would like to incorporate
this formatting step into it...

COLUMN A currently contains the following values in TEXT format:

MM-YY
03-02 would like to convert to 200203
TOTAL
04-02 would like to convert to 200204
TOTAL
05-02 would like to convert to 200205
TOTAL
FY-02
TOTAL
06-02 would like to convert to 200206
TOTAL
07-02 would like to convert to 200207
TOTAL
and on in the similar fashion for approx. 1000 entries...

i would like to convert the DATES to the following date format - yyyymm
(example- 200203)

any assistance, AS USUAL, is VERY appreciated!

Tks!
Sandi