Combining Data from 2 Colums to 1 Column

[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?

 

[Derek]

Hi
You say you want it in MMDDYY format - where is your data for the day, or is it always the first of the month?
Derek

 

[Guest]

Derek,
The data can be formatted as first of the month. Meaning if column A reads 1 (Jan) and B reads 2002, for it to combine it and paste it onto another cell as
1/1/2002. Again if A reads 2 (Feb), B reads 2002..it copies it over as 2/1/2002, etc.
thanks for your help!
vanessa