Mexcel-2010, 16 digit number's last digit changes to zero, format cell doesn't help

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.

Are these credit card numbers or similar?
Do you need to conduct any kind of calculation with them?
Where are you importing them from and how?

These are all questions we would need answered before we can provide a "non manual work" solution.

BSB

You will need to format the range as text before importing and if it still shows up as 4.9169E+15 then you'll just need to make the column wide enough to hold 16 digits.

BSB

thanks..it has helped.

Happy to help

BSB