Add Currency Symbol in Google Sheets Cells

How to add currency symbol in Google spreadsheet cells?

Explanation

Set the currency symbol to the required format using the following steps,
To set the dollar sign:
Step 1: You have two options to set currency formats for the values.
Option 1: Click dollar sign in the toolbar.

Option 2: Click Format → Number → Currency

Step 2: Selected cells will be added with the dollar symbol.

Change/Add Currency Symbol:
Step 1: Click Format → Number → More Formats → More currencies

Step 2: Custom currencies window opens up, wherein you can choose the required currency format and click Apply to apply the changes.

Step 3: Selected symbol will be added to the values in the cells.

Related Topics