How do you keep the zero in the zip codes that start with zero

Dee Randall

I put in 08601 and I get 8601. I need the complete zip.

Daniel Hauber

add an apostrophe before the number:

 

'08060

 

Or my hometown, '08108

 

darklydrawl

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.

david sim

how to solve this issue ?

 

Dan Chambers

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,