Number of significant digits allowed in a cell is 15.

[Quippian]

I need to enter a total of 16 significant digits in a cell. The problem that
I am experiencing is that the 16th digit always returns as the number "0". I
need to display the actual digit that is entered into that cell.

How can I accomplish this task?

 

[Sheeloo]

Microsoft Excel retains only 15 significant digits so you can not store and
manipulate nos with 16 significant digits after the decimal.

See http://www.cpearson.com/excel/rounding.htm for details.

 

[Mike H]

Hi,

You can display it if you precede the number with a ' which wont show in the
cell but 15 digits is the limits of precision in Excel.

Mike