View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
BB BB is offline
external usenet poster
 
Posts: 39
Default How do i change the format of a 2 digit date

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,