Add zero to beginning of number extraction

[SaraWitch]

Hello peeps,

I have a formula to extract the first number from the previous cell and would like to add a "0" in formula if one hasn't been entered previously.

¦ MrExcel Queries.xlsm
	A	B	C
1	Contact Number	Number	Text
2	01111 111111	01111 11111
3	01111 111111 (sister's number)	01111 11111	(sister's number)
4	1111111111	1111111111
Sheet3

Cell Formulas
Range	Formula
B2:B4	B2	=LEFT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{"0","1","2","3","4","5","6","7","8","9"},""))))

Any help would be appreciated

 

[SaraWitch]

Just been having a play with the other formulas, and they all work (except for one CF)! So an extra big thanks to you all!

¦ MrExcel Queries.xlsm
	A	B	C	D	E	F	G
1	Contact Number	Number	Would like!	Text	@PeteWright	@MARK858	@Scott Huish
2	01111 222333	01111 222333			01111 222333	01111 222333	01111 222333
3	01111 222333 (sister's number)	01111 222333		(sister's number)	01111 222333	01111 222333	01111 222333
4	1111222333	1111222333	01111 222333		01111222333	01111 222333	01111 222333
Extract number

Cell Formulas
Range	Formula
E2:E4	E2	=IFERROR(IF(NUMBERVALUE(LEFT(A2))<>0,"0"&LEFT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{"0","1","2","3","4","5","6","7","8","9","0"},"")))),LEFT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{"0","1","2","3","4","5","6","7","8","9","0"},""))))),A2)
F2:F4	F2	=TEXT(IFERROR(IF(NUMBERVALUE(LEFT(A2))<>0,"0"&LEFT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{"0","1","2","3","4","5","6","7","8","9","0"},"")))),LEFT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{"0","1","2","3","4","5","6","7","8","9","0"},""))))),A2),"0#### ######")
G2:G4	G2	=IFERROR(TEXT(MAX(--MID(SUBSTITUTE(A2," ",""),1,SEQUENCE(11))),"00000 000000"),"")
B2:B4	B2	=LEFT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{"0","1","2","3","4","5","6","7","8","9","0"},""))))

Wish I could mark you all as the solution, but will do @MARK858 because he got there first (even though I'm going to use @Scott Huish! )...