Excel Program Help- Can't put in zero's?

Question

I am creating a database for work. One of the columns I have designated for zip codes... if I try 02390... it will show up as 2390. How do I make it so the first zero shows up?

Answer 1

You have to do the following in the same order, (because every step reveals the one after it):

1. Select the cell or the whole column as u want it to be applied to the whole Zip codes, then go to Format->Cells
2. Select from the dialogue box "Number"
3. In Number select from Category -> Special
4. Then from locale (location) select ->English (United States) Then from Type -> Zip Code
5. Then Ok
This worked on Office 2003, I think it may work on lower versions. But mainly the whole work is in the following which is also available in other versions:
Format->Cells->Number
Hope it works

Answer 2

Highlight the column, right-click and click Format Cells. On the Number tab, in the Category field, select Text. This will ensure that the entry displays exactly as you type it.

Answer 3

Display leading or trailing zeros in a number
You can use custom number formats to retain leading zeros in numbers that you enter.

Select the cells you want to format.


On the Format menu, click Cells, and then click the Number tab.
Show Me

In the Category list, click Custom.


In the Type box, edit the number format codes to create the format you want.
Editing a built-in format does not remove the format.

To display Use this code
12 as 00012 and 123 as 00123 00000
12 as 00012 and 123 as 000123 "000"#
123 as 0123 "0"#
8.9 as 8.900 #.000
.631 as 0.6 0.#




Notes

You can use number formats to change the appearance of numbers, including dates and times, without changing the number behind the appearance.


Learn about using custom number formats for decimals and significant digits.


You can also use the & (ampersand) text operator to join, or concatenate, two values to produce one continuous text value.

Answer 4

Time and again I am amazed how elaborate are the answers of people who know absolutely nothing about the solutions.

The answer, of course, is apostrophe: whenever you want Excel to regard a number as text, just type an apostrophe in front of it and Excel would not try to correct you:
012345 = 12345
'012345 = 012345

Answer 5

Go to Format, Cells, Number, Click on Number to recognize entire numbers and not data format..

Answer 6

Go to Format _Cells_Number_Custom
Than in the Custom window type in 00000 (five zeros).
Than if you type in 1 it will automatically show 00001,
and when you type in 230 it will show 00230...