How to add currency symbol in Google spreadsheet cells?
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.