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.
Answers
-
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)
Help Article Resources
Categories
Check out the Formula Handbook template!