| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pos Pay
I need to extract numbers only and zero fill to 10 places
Ex. A123456 needs to be 0000123456 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
