May 18 2020 04:29 PM
Can someone explain this to me?
Format a cell to number with zero decimal places. Paste 8299400461135159 into the cell. Hit enter.
The number changes to 8299400461135150.
I know I can format the cell as text to show it correctly nut I want to know why it changes when it is formatted as a number.
Any ideas?
May 18 2020 06:28 PM
Solution
A Google search turned that up. 15 digits is the max. above that it starts doing what you're witnessing. Now, "WHY THAT limit...?" is another question, of course.
May 18 2020 06:41 PM
May 18 2020 06:28 PM
Solution
A Google search turned that up. 15 digits is the max. above that it starts doing what you're witnessing. Now, "WHY THAT limit...?" is another question, of course.