Sort the spreadsheet so the 4 digit numbers come up first. Insert a column
next to the Zip Code. Enter ="0"&A1 and pull down until you reach a 5 digit
code. Then copy the new leading 0 cells, and PASTE SPECIAL, Value over the 4
digit cell columns.

Hope this helps,

Carole O

"p210driver" wrote:

A text field with Zip codes is missing a Zero in front for eastern states
that only have 4numbers. How does one add a zero in front of these numbers
when the file is too large to do it individually?