Google Sheets Course: Number Format

To start, here is an example of a range of numbers without any particular format:

Number of Decimals

To set the number of decimals to display, click on .0 or .00 to decrease or increase the number of decimals:

For example, by reducing the number of decimals to 0, cell A1 will then display 20 (instead of 19.78):

Note that the application of a format only changes the display, cell A1 will always be worth 19.78 despite the format to 0 decimal:

If you want to round these numbers instead of simply changing the display of these numbers, you will need to use a function (we will come back to this later in this course).

Monetary Format

To apply the monetary format to the cell range, click on $ or choose this format from the dropdown list:

To choose another currency, click on "Custom Currency":

Percentage Format

To enter 35% (which is equal to 0.35), directly enter 35% in the cell. The number will then be displayed in percent:

You can also enter 0.35 and then click on % to change the display: