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.