If I have a cell formated as number it displays large numbers weird.
Say I enter this value into a number formatted cell :
11111111111111111111111111, after I press enter to commit the value
it changes to this : 11111111111111100000000000.

How can I get that cell to display the large number correctly?

Excel only works with 15-digit precision (see Specifications in Excel
Help). To retain more digits you must enter that number as text -
either pre-format the cell as Text before you type it in, or put an
apostrophe in front of it as you type it in.

Hope this helps.

Pee

On Dec 18, 1:44*pm, Mangler wrote:
If I have a cell formated as number it displays large numbers weird.
Say I enter this value into a number formatted cell :
11111111111111111111111111, *after I press enter to commit the value
it changes to this : 11111111111111100000000000.

How can I get that cell to display the large number correctly?

Hi,

I common with lots of other applications Excel will only calculate to 15
digits of precision. If you want to display the entire number then format as
text or prefix with a '

Mike

"Mangler" wrote:

If I have a cell formated as number it displays large numbers weird.
Say I enter this value into a number formatted cell :
11111111111111111111111111, after I press enter to commit the value
it changes to this : 11111111111111100000000000.

How can I get that cell to display the large number correctly?

two ways:

1. format the cell as Text
2. precede the value with a single quote (apostrophe)
--
Gary''s Student - gsnu200820


"Mangler" wrote:

If I have a cell formated as number it displays large numbers weird.
Say I enter this value into a number formatted cell :
11111111111111111111111111, after I press enter to commit the value
it changes to this : 11111111111111100000000000.

How can I get that cell to display the large number correctly?