Forum Discussion
XL last digit keeps going to a zero in a 16 digit string
This is an intrinsic limitation of Excel - see Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”
You could format the cell as Text, or prefix the value with an apostrophe '. But if you perform calculations with the value, the result won't be precise.
This is an intrinsic limitation of Excel - see Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”
You could format the cell as Text, or prefix the value with an apostrophe '. But if you perform calculations with the value, the result won't be precise.
Hello Hans,
I understand now i thought that it would be something about the amount of digits being to high.
I have now changed it as you have said and it has worked and the final digit is now 7.
Thank You very much for the help.
Best Regards
Darren
