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.
Get weekly updates on breaking news and business advice to help you advance your career! The week's top stories and resources will be sent right to your inbox. Choose the topics you're interested in:
We value your Privacy.