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
decimal places google spreadsheet
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.
decimal places google spreadsheet1
Step 3: Selected cells will be added with the selected decimal values as shown below,
decimal places google spreadsheet2
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,
increase decimal google sheet
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,
decrease decimal google sheet


Related Topics

Google Docs Spreadsheet Tutorial