XL's specifications (See XL Help: "Specifications") allow only 15
decimal digits of precision.

You can preformat the cell as Text or prefix the entry with an
apostrophe ('), but it will no longer be a number that you can do math
with.


In article ,
TJS wrote:

Hi all,

Quick question.

When I type in 123456789123456789 in the cell, Excel convert it into
123456789123456000 no matter cell is in number or text.
How can I display it correctly.

Thank you