Formatting Column to Display Certain Number of Digits

Hi all! Happy New Year :) Hoping for some help with formatting numbers…

For context: Employee ID #s at my company are all 8 digits, so if someone's ID # is 123456, we add leading 0s to the front so it would be "00123456" making all Employee ID #s 8-digits.

QUESTION: Is there a format-feature or formula I can use to adjust an entire column of our Employee ID #s? I need them to match exactly between sheets/columns so I can use VLOOKUP formulas, etc.

Any insight is appreciated. Thank you!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!