It is an extraordinarily large number, of course. It is 99 then three hundred and six zeros. The largest positive number that you can store in a worksheet cell is 9.9E+307. What can Excel handle #Highest and Lowest Number Limits in Excel 2013 & 2016 The precision of a number is how many digits of a number are shown.Ĭonsidering the same numbers 7.245E+3 number’s precision is 4 as it is showing that many digits.ġ.83857419E+5 number’s precision is 9 as it’s showing 9 digits.ħ.245E-5 number’s precision is 4 as it has 4 digits.Īnd lastly, 6.25431E-8 number’s precision is 6 as it is showing that many digits. In the same way, number 0.0000000625431 will become 6.25431E-8, as the decimal point has moved 8 digits right. As the decimal point has moved 5 digits right. In scientific notation, this small number, 0.00007245 becomes 7.245E-5. In scientific notation 183857.419 becomes 1.83857419E+5 as for this number, the decimal point has moved 5 digits left. So, you will express the movement with an E. So, the scientific notation is 7.245E+3, +3 as the decimal point has moved left. How? The decimal point moved 3 digits left. Let’s take a smaller number in scientific notation, 7245 becomes 7.245E+3 To use these types of numbers conveniently, you can express them in scientific notation. For example, you have a very large number like this: 1234567894578215153456789, this number has 25 digits. Sometimes, especially while using a calculator, you may end up with a very long number.
#EXPONENT ON EXCEL FOR MAC DOWNLOAD#
Download Working File How Scientific Notation Works