Add a warning when values Get Truncated and replaced with Zeros greater than 15 Char in length
I find it sneaky and arbitrary that values get replaced with Zeros if they exceed 15 characters in length. If there was a comment inserted into the cell that zeros were used instead of using all the digits. While this may or may not result in significant digits, it should at least give us a warning in the cell.
Excel Calculates 23,922,711,173,386,400
So it rounds up to 15 numbers non zero. Not sure why, but it difficult to find if you are not checking your work in something other than excel. Either calculate it correctly, or add a warning/comment, that precision is lost. That way we are not relying on a number that is not entirely correct.