I need to extract numbers only and zero fill to 10 places Ex. A123456 needs to be 0000123456
M Melissa Jul 22, 2008 #1 I need to extract numbers only and zero fill to 10 places Ex. A123456 needs to be 0000123456
T T. Valko Jul 22, 2008 #3 Assuming the number portion always starts at the 2nd character. This returns a TEXT string. =TEXT(MID(A1,2,10),"0000000000") If you want the number to remain a numeric number: =--MID(A1,2,10) Then custom number format as 0000000000
Assuming the number portion always starts at the 2nd character. This returns a TEXT string. =TEXT(MID(A1,2,10),"0000000000") If you want the number to remain a numeric number: =--MID(A1,2,10) Then custom number format as 0000000000
