If you see the wrong currency in Google services, it could be because of incorrect locale settings in your Google account. We are going to show you how to set the correct locale on Google.
Adjusting the locale makes your life easier using services like Google Sheets, which don̵
RELATED: The beginner’s guide to Google Sheets
Set the default currency for all spreadsheets in Google Sheets
The default currency settings in Google Sheets are linked to the preferred language in your Google account. To make sure the correct currency is selected as the default, go to the language settings page for your Google account and click the pencil icon under the “Preferred Language” section.
Enter your preferred language in the search box. To select the US dollar as the default currency, select “English”.
Now select ‘United States’.
Once you have done this, the default currency will be set to US dollars.
Make sure the correct currency is set as the default
You can use Google Sheets to check if the correct currency is set as the default in your Google account. Go to https://docs.google.com/spreadsheets/ and create a new spreadsheet.
Click Format> Number and check the symbol next to ‘Currency’. This should reflect the currency symbol for the language you selected in your Google account. For example, if you selected English (United States) as the language, you will see the US dollar symbol (“$”) here.
Change the currency for one Google spreadsheet
If you’ve set the default currency and you want to change it for just one particular spreadsheet, here’s what you need to do.
Open a new spreadsheet in Google Sheets and go to File> Spreadsheet Settings.
Click the “General” tab in the “Settings for this spreadsheet” box.
Under ‘Locale’, select the region whose currency you want to use as the default currency.
Click “Save Settings” when you are done. This changes the default currency and date format for this spreadsheet.
Set cells to “Currency” format in Google Sheets
To avoid typing the currency symbol over and over again, you can set cells in Google Sheets to the “Currency” format. To do this, select the cells whose currency format you want to change.
From the menu, select Format> Number.
Click on ‘Currency’.
From this point on, all you have to do is type the number in all these cells and Google Sheets will automatically add the correct currency symbol.
Once you get the hang of this, you may want to try learning the best Google Sheets keyboard shortcuts.
RELATED: All the best keyboard shortcuts for Google Sheets