Add leading zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a CAS# field that Excel interprets as a number. As a result, all my
leading zeros are dropped. Is there a way for me to add leading zeros to any
given number to make it become 9 digits?

For instance, I'd like the following to happen:

12345 to become 000012345
123456 to become 000123456
1234567 to become 001234567
12345678 to become 012345678
123456789 to remain 123456789

Thanks to whomever can help me!!

Ellen
 
You can format the cell(s) as "000000000" (minus the quotes) and this will
insert leading zeros as required.

HTH
 
You're beautiful!! Thanks, Toppers.

Toppers said:
You can format the cell(s) as "000000000" (minus the quotes) and this will
insert leading zeros as required.

HTH
Click to expand...
 

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

Reformat numbers 6
Add hyphens 3
insert a dash 5
Add leading zeros 5
Add leading zeros and concatenation 4
Keep Leading Zeros in Concatenation 5
Adding a leading zero "0" to a number in a cell 2
Re: Convert Number to Text and keep leading zeroes 1

Back
Top