Right click in an empty cell and choose "Format Cells".
Click on "SPECIAL".
Click on "Zip Code", then <OK.

Right click in this cell again and choose "Copy".
Select your text number cells,
Right click in this selection and choose "Paste Special".
Click on "Add", then <OK, then <Esc,
And you're done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"p210driver" wrote in message
...
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?