How to set decimal values for numbers in Google Docs Spreadsheet?
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,