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

Graham159

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.

Carson Penticuff

This should give you result you want visually. With this, you lose the "number" formatting and the Store No is treated as text.

=IF(LEN([Store]@row) = 3, "0" + [Store]@row, [Store]@row)