XL stores only 15 decimal digits of precision. If your numbers were
longer than that, the remaining digits are lost.

In article ,
Sonja wrote:

I have a problem that hopefully can be solved. I have a spreadsheet that has
been changed from text to numbers. I am aware that the last number will
change to "0" however, once you convert the text to numbers is there a way to
convert back to get the original number. When I convert the column back to
text it still comes up as a "0".