Jul 27 2021 05:06 AM
Hi,
I have a 16 digit number in a cell in xl and it keeps going to zero when entered.
So the last four numbers are 6167 and the cell keep returning to 6160.
When I split the number into two cells each with 8 numbers they stay the same.
I have tried the cell size and the decimal point increasing as I have seen on forums but these do not work.
I have tried to format the cell in different ways but this does not work.
I can only assume that it is the number of digits "16" has something to do with it? can I turn this function off in some way as I want a 7 at the end of the number and not zero?
Thanks
Darren
Jul 27 2021 05:12 AM
SolutionThis 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.
Jul 27 2021 05:56 AM
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
Jul 27 2021 05:12 AM
SolutionThis 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.