Excel HELP...with entering numbers...?

Question

My first question is how you do you enter the numbers 0012345 without excel taking out the zero's?

My second question is how do you enter 46E82 without excel changing it?

Thanks...

Answer 1

You can do the first one of two ways. Either type an apostrophy (') in front of the number like '0012345, which tells Excel to treat it as "text" instead of a number, so it will leave the zeros alone (but you can't do math with it)

Or go into Format > Cells and set it as a number with the format "0000000" (or however many digits you want). Then all number in that cell will display with that many digits.

For the other, since it is actual "text" and not a number, use '46E82 to force it to display as text.

Answer 2

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.

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.#

Second questions, select the column, click Format, cell, click Text.

Answer 3

Format the cell to the custom number format "0000000" to keep the leading zeros.

To keep 46E82 as text lead it with an apostrophe '46E82. Excel then translates it as text rather than as a number.

Answer 4

Format cells as text.
Select the cells then select "Format" from the menu - select "cells" from the menu list, then select "Text" as the format type.

Answer 5

The quickest is to put a ' in front of the number...like this
'00012345