Pos Pay
 

I need to extract numbers only and zero fill to 10 places

Ex. A123456

needs to be 0000123456

Pos Pay
 

=TEXT(RIGHT(A1,LEN(A1)-1),"0000000000")

"Melissa" wrote:

I need to extract numbers only and zero fill to 10 places

Ex. A123456

needs to be 0000123456

Pos Pay
 

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

--
Biff
Microsoft Excel MVP


"Melissa" wrote in message
...
I need to extract numbers only and zero fill to 10 places

Ex. A123456

needs to be 0000123456