see response in worksheet.functions.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"BB" wrote in message
...
How do i change the format of a 2 digit date in months to a four digit
showing years and months?

34 = 0210
11 = 0011
45 = 0309

I have a series of months in each cell like 34. I want to create a
formula
where it will show 0210. Thats 2 yrs and 10months. It can be a text
format
cell.

Thanks,