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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!