Google Sheets is home to several spreadsheets for tracking expenses and budgets. Most of these choose a default currency, but if you want to change that, you’ve come to the right place. Here’s how to change the currency symbol in Google Sheets.
We recently started using one of these spreadsheets for tracking expenses on Google Sheets and surprisingly the currency chosen was British Pounds. You can easily exchange that to US dollars or other currencies.
If you downloaded a template with a different currency, make sure that all instances of the currency have been changed. Failure to do so may result in calculation errors or other problems.
Change currency symbol manually in Google Sheets
This method is a bit cumbersome, but you can change the currency symbol quite easily in Google Sheets. You must first open a spreadsheet and then select all cells with the currency you want to change. If the entire sheet has only one currency, you can simply use the keyboard shortcut Control+a (or Command+a on Mac).
With the relevant cells selected, click the “123” button next to the font selection option.
Select ‘More formats’.
Click on ‘More currencies’.
Use the search box to find and select your currency.
Click the currency format drop-down menu to select the desired format. You will see choices like US$1,000, $1,000, USD1,000, etc. Pick one of these.
Now click on ‘Apply’.
This changes the currency symbol in one worksheet. You will need to repeat this process with other worksheets to resize there as well. This means that if your Google Sheets document has separate worksheets such as income, expenses, etc., you will need to manually change the currency symbol in each of them.
Set the default currency for each document in Google Sheets
When you create a new spreadsheet in Google Sheets, you can quickly set the default currency for that document.
Note: This method will not work with templates that have their own default currencies. It works best with new Google Sheets docs you’re working on.
To set a default currency for your spreadsheet, click “File” in Google Sheets.
Choose ‘Spreadsheet Settings’.
Go to the “General” tab. You’ll see a drop-down menu with a country’s name under the “Local” subheading. Click on that drop-down menu.
Select the country whose currency you want to use.
Finally, click on the green “Save Settings” button. Sets the document’s default currency to the currency you want.
RELATED: All the best keyboard shortcuts for Google Sheets
Set the default currency for your Google account
If you want to make sure your preferred currency is always set as the default in Google Sheets, you can make the change directly in your Google account. To do this, sign in to your Google account and click on your profile picture in the top right corner.
Choose “Manage your Google Account.”
Click on “Manage your data and personalization” in the Privacy and Personalization section.
Select the pencil icon next to your preferred language.
Use the search box to select the primary language of the country whose currency you want to choose. In our case, we want to select the US dollar as the default currency, so we chose ‘English’.
Now select the correct country. For US dollars, the choice is ‘United States’.
Click the “Select” button to complete the process.
You can also learn how to change the date format in Google Sheets here.
RELATED: How to change the default date format in Google Sheets