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

[Guest]

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?

 

[Guest]

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

 

[Guest]

Format > Cells... > Number > Custom > and then 00000 in place of General

 

[RagDyer]

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!