Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I put in 08601 and I get 8601. I need the complete zip.
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,
