i am trying to enter zip codes that start with 0 and Excel does not recognize the 0 and drops it-leaving a 4 digit number. how do i fix that????
2007-10-07 08:00:21 · 4 answers · asked by mom is a freak 3 in Computers & Internet ➔ Software
select the cell with the zip code, (if it's a column, select the whole column)
right click, select "Format Cells"
On the first tab "Number", select the category as "Custom"
On the "Type" text box, type "00000". (The length that you desire - ZIP Code - 5 characters so 00000)
Press "enter".
2007-10-07 08:11:10 · answer #1 · answered by kumarika 2 · 2⤊ 1⤋
Click on
Format > Cells > Under the "Number" tab: select "Special "
and select Zip Codes
Click ok
2007-10-07 08:10:27 · answer #2 · answered by BikerChick 2 · 1⤊ 0⤋
you have to right click the cell you are entering the number into then change the format of the number so the zero at the start will be included
2016-03-17 08:42:55 · answer #3 · answered by ? 3 · 0⤊ 0⤋
Format the cells so that numbers are "00000".
It will always be 5 digits.
2007-10-07 08:09:10 · answer #4 · answered by Baccheus 7 · 0⤊ 0⤋
You can enter the number preceded by an apostrophe, like '01234. This will take the input as a text input.
2007-10-07 08:15:57 · answer #5 · answered by Eechhutti 2 · 1⤊ 1⤋
Format the cell as text. It will then display the leading zero
2007-10-07 08:08:46 · answer #6 · answered by marystoy_2000 5 · 0⤊ 0⤋
Thank you everyone for answering!
2016-08-26 01:59:01 · answer #7 · answered by Anonymous · 0⤊ 0⤋