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,Β