Adding 0 to the front of a number

  • Thread starter Thread starter Staten42
  • Start date Start date
S

Staten42

I have a data set that has a 5 digit id field with the first id being 00001.
How can I add the zeros i need to a similar data set that doesn't currently
have the zeros in front to make the 5 digit character?

Any help would be awesome!
 
Format cells>Custom> Type: 00000

If you need to combine this with any formulas to reflect the text with 5
digits you can use the below formula
TEXT(A1,"00000")

If this post helps click Yes
 
If the lookup value and array value is formatted to display 00000 then you
dont need to.

If this post helps click Yes
 

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

Custom number format 12
put 0 in front of number 6
how do I add a zero in front of a bunch of 4 digit numbers? 7
How do I remove the apostrophe(') in front of zeros 3
adding a trailing zero 5
length principle of a number within a cell 1
trying to insert a 0 in front of zipcode 2
How add a digit to front of number in each cell in excexl column 1

Back
Top