Tips

[Tips] How to Change the Currency Symbol in Google Sheets

Change the Currency Symbol in Google Sheets

Overview

We recently started using one of these expense-tracking spreadsheets on Google Sheets, and surprisingly, the chosen currency was British pounds. You can easily change that to U.S. dollars or other currencies.

how to change the currency symbol

If you downloaded a template featuring a different currency, you’ll have to make sure that all instances of the currency have been changed. Failure to do so could result in calculation errors or other issues.

Change the Currency Symbol Manually

This method is a bit cumbersome, but it does allow you to change the currency symbol quite easily in Google Sheets. You’ll need to open any spreadsheet first and then select all the cells containing the currency that you want to change. If the entire sheet has just one currency, you can simply use the Control+a (or Command+a on Mac) keyboard shortcut.

Select all the cells in Google Sheets

With the relevant cells selected, click the “123” button that’s next to the font selection option.

Select “More Formats.”

Click More Formats

Click “More Currencies.”

Click More Currencies

Use the search box to find your currency and select it.

Click US dollar

Click the currency format drop-down menu to select the format that you prefer. You’ll see choices such as US$1,000, $1,000, USD1,000, etc. Pick any of these.

Click the currency format drop-down menu

Now, click “Apply.”

Click Apply

This will change the currency symbol in one worksheet. You’ll have to repeat this process with any other worksheets to change the format there, too. This means that if your Google Sheets document has individual worksheets such as Income, Expenses, etc., you’ll have to manually change the currency symbol in each.

Set the Default Currency for Any Document

If you’re creating a new spreadsheet in Google Sheets, you can quickly set the default currency for that document.

To set a default currency for your spreadsheet, click “File” in Google Sheets.

Click File

Choose “Spreadsheet Settings.”

Click Spreadsheet Settings

Go to the “General” tab. You’ll see a drop-down menu with the name of a country under the “Locale” subhead. Click that drop-down menu.

Click the drop-down under Locale

Select the country whose currency you wish to use.

Click United States

Finally, just click the green “Save Settings” button. This will set the default currency of the document to the one you want.

Click Save Settings

 

Set the Default Currency for Your Google Account

If you want to ensure that your preferred currency is always set as the default in Google Sheets, you can make the change directly to your Google account. To do this, log in to your Google account and click your profile picture in the top-right corner.

Click your profile picture

Choose “Manage your Google Account.”

Click Manage your Google Account

Click “Manage your data & personalization” in the Privacy & personalization section.

Click Manage Data & Personalization

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’d like to select the U.S. dollar as the default currency, so we chose “English.”

Click English

Now, select the correct country. For U.S. dollars, the choice is “United States.”

Click United States

Click the “Select” button to finish the process.

Click Select

After finish change the currency Symbol in Google Sheets, You can also check out how to change the date format in Google Sheets here.

Read more :

 

Related Articles

Leave a Reply

Back to top button