G
Guest
Guest
I have two colums one with Year in 2002
format, another with the month in the 1, 2, 3, 4 format. I need it to be in the MMDDYY format
Column A | B | C | D |
so 2002 | 1 | Data | MoreData|
will be copied to ANOTHER SHEET as
Column A | B | C | D
1/1/2002 | dATA | mORE dATA |
How do I combine this in a macro?
format, another with the month in the 1, 2, 3, 4 format. I need it to be in the MMDDYY format
Column A | B | C | D |
so 2002 | 1 | Data | MoreData|
will be copied to ANOTHER SHEET as
Column A | B | C | D
1/1/2002 | dATA | mORE dATA |
How do I combine this in a macro?