Large Number Question

[Mangler]

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?

 

[Pete_UK]

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

 

[Mike H]

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

 

[Gary''s Student]

two ways:

1. format the cell as Text
2. precede the value with a single quote (apostrophe)