4 ms·
Excel only stores 15 significant digits. Once you get to the 16th digit you'll just get a zero. Example: 6,190,283,353,629,370 + 1 will still be 6,190,283,353,
by lavezza 4y ago
Excel only stores 15 significant digits. Once you get to the 16th digit you'll just get a zero.
Example:
6,190,283,353,629,370 + 1 will still be 6,190,283,353,629,370.
6,190,283,353,629,370 + 10 will be 6,190,283,353,629,380