ZIP codes with leading zeroes — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

ZIP codes with leading zeroes

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