Before creating or editing a spreadsheet in Google Sheets, make sure the default currency for the document matches your expectations. Here’s how to change the default currency and check it in existing spreadsheets.
Set the default currency for all sheets
To set the default currency for all new Google Sheets, go to your profile language settings at https://myaccount.google.com/language. After you select your language in the ̵
For existing sheets, you must manually change the currency for each sheet using the method described below.
Set the default currency for the current sheet
Google Sheets remembers the currency setting for each sheet individually. You can change this by setting your current locale. To do this, open your favorite web browser and go to Google Sheets. Then load the spreadsheet for which you want to change the currency.
Once it loads, click File > Spreadsheet Settings from the menu at the top of the page.
In the “Settings for this spreadsheet” window that appears, click the “General” tab.
Under ‘Local’ you will see a drop-down menu with the names of different countries. Choose the country whose currency you want to use. For example, if you want to set US dollars as the default currency, select “United States.”
Click ‘Save Settings’ when you are done.
After you change your locale, any monetary amounts already entered on the sheet will be automatically translated to the currency format of the locale you selected, and any currency values you enter after that will match the locale. This change only applies to this one spreadsheet.
Check if the correct currency is set as default
To verify that the correct currency is set as the default, click the ‘Format’ menu and select ‘Number’.
Find “Currency” in the list and make sure you see the correct symbol for the currency you selected (for example, the dollar sign (“$”) in the US).
Set cells as “currency” format in Google Sheets
In Google Sheets, you need to set cells as “currency” to see the currency symbol correctly. Once it’s set up, you can type any number and Google Sheets will automatically add the currency symbol to those cells. Here’s how to do it.
First, start by selecting the cells where you want to display currency symbols.
When you’re done selecting, click Format > Number from the menu.
Select ‘Currency’ from the list that appears.