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.
currency google sheet
Option 2: Click Format Number Currency
currency google sheet2
Step 2: Selected cells will be added with the dollar symbol.
currency google sheet1
Change/Add Currency Symbol:
Step 1:
Click Format Number More Formats More currencies
currency google sheet3
Step 2: Custom currencies window opens up, wherein you can choose the required currency format and click Apply to apply the changes.
currency google sheet4
Step 3: Selected symbol will be added to the values in the cells.
currency google sheet5


Related Topics

Google Docs Spreadsheet Tutorial