I have a long list in excel and some of the zeros in front of the zipcodes are not there. I would like to figure out an easy way of adding them in other than manually typing them. Thanks!
2007-07-17 05:36:05 · 7 answers · asked by DNA26 1 in Computers & Internet ➔ Programming & Design
This formula will add a "0" to any that need it, and will convert the rest to text, so you can use it for all of your zip codes:
=TEXT(A1,"00000"), where the zip is in A1
Hope that helps.
.
2007-07-17 05:45:52 · answer #1 · answered by aladou 5 · 0⤊ 1⤋
1. Click Format->Cells menu item.
2. Click Custom in the list box.
3. Select Special as the format.
4. Select ZipCode.
5. Click OK.
2007-07-17 05:43:03 · answer #2 · answered by The Phlebob 7 · 0⤊ 0⤋
format the cell. Under the Number tab go to special and do Zip Code.
2007-07-17 05:41:07 · answer #3 · answered by Spider 2 · 0⤊ 0⤋
You need to format it as a zip code field (FORMAT > SPECIAL > Zip Code)
Another alternative, if you have numbers you would like to add a 0 to in column A, then in column B type this formula:
=CONCATENATE("0",A1)
2007-07-17 05:39:46 · answer #4 · answered by Samuel Adams 7 · 1⤊ 1⤋
Try setting the columns like ="01234"
2007-07-17 05:42:15 · answer #5 · answered by Pfo 7 · 0⤊ 0⤋
set the cell/column format as text
2007-07-17 05:39:36 · answer #6 · answered by ohio44903 5 · 1⤊ 1⤋
Use this mark first '
2007-07-17 05:39:49 · answer #7 · answered by whymewhynow 5 · 1⤊ 1⤋