Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How do you keep the zero in the zip codes that start with zero
I put in 08601 and I get 8601. I need the complete zip.
Comments
-
add an apostrophe before the number:
'08060
Or my hometown, '08108
-
Just like in Excel. Nice. I also noticed that you have cleverly programmed the same short cut keys to work the same. For Example 'control+d' for duplicate cell(s) down.
NIce work on that folks. -
how to solve this issue ?
-
I'm not sure it will help too much with US Zip Codes, but I had a similar problem with UK telephone numbers.
Instead of inserting an apostrophe (as suggested above), which is a pain and screws up any auto dialling) I found that a space or hyphen after the area code makes SS keep the starting zero.
Does the Zip Code have to be a contuinuous string (08601), or would 08 601 or 08-601 still parse?
All the best,
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives