Increase number of digits

[Philatelist]

Hi, I have a random number of digits, could be between 1 and 6, possibly containing a prefix letter, but I need the numeric string to be 12 digits long. How can I add the correct number of leading 0's to make 12?

So for instance in cell A1 I have the number T777, I need cell B1 to read 000000000777.

In Cell A2 I have 1234, I need B2 to read 000000001234

Thanks in advance, I'm sure one of you guys can solve in minutes!

A~

 

[arthurbr]

Custom format as 000000000000
(12 zeroes)

 

[Fluff]

How about

=TEXT(IF(ISERROR(LEFT(A2)+0),MID(A2,2,100),A2)+0,REPT(0,12))

 

[awoohaw]

if only there is one prefix letter:

mr excel questions 24.xlsm
	A	B
1	T777	000000000777
2	1234	000000001234
Philatelist

Cell Formulas
Range	Formula
B1:B2	B1	=TEXT(IF(ISNUMBER(1*LEFT(A1,1))=FALSE,RIGHT(A1,LEN(A1)-1),A1),"000000000000")

 

[Philatelist]

Fantastic response thanks, Arthurbr, your solution doesn't seem to take into account the possible Prefix letter, Fluff and Awoohaw, both solutions worked perfectly.
Dare I follow up though with a basic beginners question? If A1 is empty, what is the simplest method of making B1 appear empty also instead of #VALUE!
Thanks again

 

[Fluff]

How about

=IF(A2="","",TEXT(IF(ISERROR(LEFT(A2)+0),MID(A2,2,100),A2)+0,REPT(0,12)))

 

[Philatelist]

Perfect Fluff, much appreciated.

 

[Fluff]

Glad we could help & thanks for the feedback.