Set Decimal Values for Numbers in Google Sheets

How to set decimal values for numbers in Google Docs Spreadsheet?

Explanation

Add decimal values to the number using any of the following options,
Step 1: Click Format → Number → More Formats → Custom number format

Step 2: Custom number formats window opens, wherein you can choose the decimal format in which you want the number to be displayed. Click Apply to apply the changes.

Step 3: Selected cells will be added with the selected decimal values as shown below,

Increase Decimal Places:
Increase the decimal places by using the simple steps,
Step 1: Click the "Increase decimal places" in the toolbar.
Step 2: Decimal places will be increased by two digits as shown in the below image,

Decrease Decimal Places:
Decrease the decimal places by using the simple steps,
Step 1: Click the "Decrease decimal places" in the toolbar.
Step 2: Decimal places will be decreased by a single digit as shown in the below image,

Related Topics