View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BB BB is offline
external usenet poster
 
Posts: 39
Default Convert 2 digit month to 4 digit years and months

How can i convert a 2 digit number of months to a four digit showing years
and months?


35 = 0211
24 = 0200
05 = 0005

I have a series of numbers containg months, like 35. I want it to come out
to years and months 0211. 35 months is 2 years and 11 months. I want it to
show 0211.

Thanks,