How do i change the format of a 2 digit date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
see response in worksheet.functions.

--
HTH

Bob Phillips

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