Pos Pay

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

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

Ex. A123456

needs to be 0000123456
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Unique Cells, within a date range (dates stored in separatecolumn). 3
How do I make a field zero filled in Access 2002 2
Dates - Custom - Pos Pay Format 3
POSTIVE PAY FILE FORMAT 4
POS 5
Update Query 2
11 digits 3
Validation not working 8

Back
Top