How do I add a zero in front of a text formatt number?
 

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?

How do I add a zero in front of a text formatt number?
 

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?

How do I add a zero in front of a text formatt number?
 

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?

How do I add a zero in front of a text formatt number?
 

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?