Convert 2 digit month to 4 digit years and months

=?Utf-8?B?QkI=?=

Guest

Posts: n/a

17th Sep 2006

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,

« special formatting? | Adding rows? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change a list of 2 digit years to 4 digit years?	=?Utf-8?B?RnJlZGd1cw==?=	Microsoft Excel Worksheet Functions	5	3rd Oct 2007 10:04 PM
NEED EXCEL FORMULA TO CONVERT 13 DIGIT ISBN TO 10 DIGIT ISBN	=?Utf-8?B?RG9uX1F1aXhvdGU2MA==?=	Microsoft Excel Misc	7	1st Apr 2007 10:58 PM
Convert 2 digit month to 4 digit years and months	=?Utf-8?B?QkI=?=	Microsoft Excel Worksheet Functions	4	17th Sep 2006 09:33 PM
Re: how to convert single digit to month name	Dave Peterson	Microsoft Excel Worksheet Functions	2	26th Apr 2006 11:53 PM
Adding leading zero to convert one digit hex values like 0,1,2,A in to two 2 digit hex values like 01,02,0A	Rich	Microsoft Access Queries	1	22nd Sep 2003 10:34 PM