Why does Excel, drop beginning zeros in zip codes on mailing label

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When we print mailing labels, Excel drops the beginning zero in zip codes
causing us to have to add them manually. We are working with thousands of
labels and this is very time consuming.
Thank you
Kate
 
If you add an apostrophe to the front of the zip code, this shouldn'
happen. It forces Excel to recognise the characters as a string instea
of a number
 
Go to Format - Cells on top menu toolbar
On the Number Tab, in the left window click on Special
In the Locale dropdown, click English (United States)
You can now select Zip Code and any entry in the cell will retain formatting
 
mrice said:
If you add an apostrophe to the front of the zip code, this shouldn't
happen. It forces Excel to recognise the characters as a string instead
of a number.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10931
View this thread: http://www.excelforum.com/showthread.php?threadid=535337

Thank you will try it
Click to expand...
 
Back
Top