How to Add Zeros to a # to Equal a Total of 4 Digits


Hi, I have a column with store #'s that have less than 4 digits, I'd like a second column to adjust the number to equal 4 total digits.

Example 829 to 0829

I have 6k+ rows so I'd like to not have to do this manually. I formatted them how I wanted in excel but when I imported it adjusted them to "829". I can copy/paste from excel just that column but can only copy 500 rows at a time and doing 6k would take forever.

I saw someone suggest putting the "Store No" column as a Contacts column and not text/# column and it would hold the formatting but that didn't work.

Column "Store No" is how I would like it to appear.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!