Re: NEED HELP..CONVERT NUMBERS BACK TO TEXT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

In article <14931B24-C2F7-4FB4-91AA-D732D356EDB1@xxxxxxxxxxxxx>,
Sonja <Sonja@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have a problem that hopefully can be solved. I have a spread*** 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".
.

Quantcast