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
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