Way to format cell to not change the number as it is typed in

[bdouglas1011]

I have a cell e6 on a worksheet that is formatted as "general" the problem is that the number being entered is (422553376600) that is what I want displayed.

The cell returns (4.22553E+11) how do I get it to not do this?

[JieJenn]

change the numberformat to number for the entire column?

[MrShorty]

When a cell is formatted as general, Excel will automatically revert to scientific notation whenever the column is too narrow to display the full integer. Note that this does not change the cell's value, the cells value is still the integer 422553376600, it only affects the display.

One solution: widen the column so that there is adequate room to display a 12 digit integer.

Another solution: format the column as "0". However, this means that any number too large to fit in the column width will display as "########" which is Excel's way of saying that it cannot display the cell value in the desired format. Again, the cell value is still correct, but the display is "undesirable"

Another solution: enter the number as a text string (precede with an apostrophe). This will store the number as text, which will display as text instead of number, but can create other issues if this value will be used in other formulas.

Do any of those help?