Situatie
Google Sheets is home to several expense-tracking and budget spreadsheets. Most of these pick a default currency, but if you want to change that, we have you covered. Here’s how to change the currency symbol in Google Sheets. I 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 other currencies.
Solutie
Pasi de urmat
Change the Currency Symbol Manually in Google Sheets
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.
With the relevant cells selected, click the “123” button that’s next to the font selection option.
Select “More Formats.”
Click “More Currencies.”
Use the search box to find your currency and select it.
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.
Now, 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.
Leave A Comment?