Big Number & Excel

K

Kyaw Soe Lin

Dear All,

When I am trying to enter the 16 digits number into the
Excel, the last digit always change to 0.

e.g-
5548890134383945 will change to 5548890134383940

I tried to change the format of cell to Number, Currency,
Accounting, etc... and the result is same except Text
format. But, I can't do calculation with Text format.

Please help me how to enter the 16 digits number and
calculate in Excel.

Thanks...
Kyaw Soe Lin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top