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?

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?

Format Cells... Number Custom and then 00000 in place of General
--
Gary's Student


"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?

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?