Write the numbers in a vertical list, lining up the decimal points. If the numbers have a different amount of digits, there may be some gaps in the columns. Fill in any gaps with a zero so that each ...

Excel displays the original number up to 11 digits. When you enter a number that has more than 11 digits, Excel does not display the original value. Instead, it displays the number in the exponential ...