Before you create or edit a spreadsheet in Google Sheets, it’s a good idea to make sure the document’s default currency is what you expect. Here’s how to change the default currency and how to verify it in existing spreadsheets.
Contents:
- How to set default currency for all sheets
- How to set default currency for current sheet
- How to check if the correct currency is set as default
- How to Set Cells as “Currency” Format in Google Sheets
How to set default currency for all sheets
To set the default currency for all new Google Spreadsheets, go to your profile language settings at https://myaccount.google.com/language. Once you’ve selected your language in the “Preferred language” section, Sheets will assume that you want to use the currency of your default language region in all new sheets you create in the future.
For existing sheets, you will need to change the currency manually for each sheet using the method described below.
How to set default currency for current sheet
Google Sheets remembers the currency setting for each sheet individually. You can change it by setting your current locale. To do this, open your favorite web browser and visit Google Sheets. Next, load the spreadsheet whose currency you want to change.
Once loaded, 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’ll see a drop-down menu displaying the names of various countries. Choose the country whose currency you want to use. For example, if you want US dollars to be the default currency, select “United States”.
Click “Save Settings” when you’re done.
After changing your locale, all money amounts already entered in the sheet will automatically be converted to the currency format of the language you selected, and any currency values you insert after this point will match the language. This change applies only to this worksheet.
How to check if the correct currency is set as default
If you want to check that the correct currency is set as default, click on the “Format” menu and select “Number”.
Find “Currency” in the list and make sure it displays the correct symbol for the currency you selected (the dollar symbol (“$” in the United States, for example).
Number in Google Sheets” width=”650″ height=”500″ onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this); » onerror= »this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this); »>
If it’s correct, then you’re good to go. If not, revisit the section above to change your locale.
How to 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, you can type any number and Google Sheets will automatically add the currency symbol to those cells. Here’s how.
First, start by selecting the cells where you need to display the currency symbols.
Once the selection is complete, click Format > Number from the menu.
In the list that appears, select “Currency”.
Number in Google Sheets” width=”650″ height=”500″ onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this); » onerror= »this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this); »>
This will convert all the cells you selected to “Currency” format. Type any number in these cells and Sheets will automatically add the currency symbol for your locale.
Now that you’ve learned the basics, you might also like to learn how to convert currencies in Google Sheets. Good luck!
