What are the two formats for numbers? What is the difference between them?
August 31, 2020 | Education
| Numbers in a spreadsheet are represented in fixed point (common) and floating point forms. Writing a numeric constant in fixed-point form assumes that the number contains an integer and a fractional part, separated by a decimal point. When writing a numeric constant in the form of a floating point, the mantissa is written first, then the Latin letter E, after which the order.
