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,
Bob Phillips - 17 Sep 2006 21:31 GMT
see response in worksheet.functions.

Signature
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
> How do i change the format of a 2 digit date in months to a four digit
> showing years and months?
[quoted text clipped - 8 lines]
>
> Thanks,