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
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives