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

 

[MARK858]

You're welcome (I'd mark Scott's as the solution if you're using that one btw), happy we could help