Hi,

I have to sane large number(16 digit number) in excel 2010. However, the last digit always changes to zero and second last digit also changes some time. I know that it must be due to limitation of saving numbers upto 15 digits and then rounding it of. As a workaround, i tried formatting the cell as text, but then it is shown in exponential format like : 4.9169E+15. The actual number is 4916895528499807, but it is saved as 4916895528499810. Here last two digits are changed. How to solve this issue as save the number 4916895528499807 as it is. I have to save such 5000 numbers, so manual work will not help..Please help.