• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

ZIP codes with leading zeroes

Get PDF file

by on
in Excel Training,Office Technology

Q. ZIP codes with leading zeroes don’t come over correctly in a mail merge. Formatted using the Special format, ZIP Code doesn’t work. What can I do to fix this?

A. Try inserting a blank column to the right of the ZIP code column. Type, =TEXT(F2,”00000”), where F2 is the cell holding your first ZIP code. Double-click the AutoFill handle to copy it to the bottom of your column. Then, copy all the results (Ctrl+C) and use Paste Values (or Paste Special, Values) and paste it over the original ZIP codes. Now all ZIP codes will have the requisite five characters including a leading zero, if needed.

Leave a Comment