Setting the number of decimal places, in the number format, to 2.
Chat with our AI personalities
FORMAT / Format Cells / Number tab / Number / 'Decimal places' window / fill in '2'.
To the left of the decimal point, you place a decimal at an interval of every three digits.
Pi has been calculated to over 100 billion decimal places. This answer format cannot display more than a few thousand of the digits.(The term "digits" includes the number 3 at the start.) * See the related links to the 1 million and 1 billion-plus sites
Currencies usually default to 2 dp.
-- Select the range of cells.-- Pull down Format \ Cells \ Number \ Decimal Places: (fill in '3')