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
 
Back
Top