View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sonja Sonja is offline
external usenet poster
 
Posts: 6
Default NEED HELP..CONVERT NUMBERS BACK TO TEXT



"JE McGimpsey" wrote:

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