Forum Discussion
Can anyone explain this behaviour?
In an empty workbook, I entered 49 in B1 and =1/(1/B1) in C1, then saved the workbook.
This is how these cells are stored in the XML representation of the worksheet:
As you see, the stored value of C1 is 49.000000000000007, not 49. However, since the 7 is the 17th digit, Excel cannot display it, even if you format C1 as Number with 20 decimal places.
JoeUser2004 Thank you for pointing out the sloppiness in my (lack of) parentheses. However, I did have the parentheses in the correct place in the SS. I'll put my sloppiness down to (a) being late at night and (b) having to rewrite the question 3 times because the webpage refused to accept my question while I had any tables or code in my answer. (like SergeiBaklan 's answer - HOW DID YOU MAKE THAT WORK?) Could not click Post until all my careful formatting had been removed.
I'll put my sloppiness down to (a) being late at night and (b) having to rewrite the question 3 times because the webpage refused to accept my question
Been there, done that. 😂 😀