Figures with more than 15 characters

[kamiel]

Hello,

When I enter figures with more than 15 characters, Excel rounds the characters starting from position 16.

Is there a possibility to turn that feature off?

Thanks,

Kamiel

 

[Carl B]

Format the cell to be a Number instead of General

 

[kamiel]

The format is number. All characters starting from position 16 become 0.

 

[Carl B]

I'm sorry, I did not check further on that.
According to Excel help:

Excel specifications and limits


Calculation specifications

Feature Maximum limit
Number precision 15 digits
Largest number allowed to be typed into a cell 9.99999999999999E+307
Largest allowed positive number 1.79769313486231E+308
Smallest allowed negative number -2.2251E-308
Smallest allowed positive number 2.229E-308
Largest allowed negative number -1E-307
Length of formula contents 1,024 characters