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,
