How to add or change the currency in Google Sheets
Commission may be earned if you purchase through links on this site - learn more
Many people use spreadsheets to record financial transactions. When entering numbers into a spreadsheet, by default, you’ll not see a currency. Instead, the numbers are entered without any association to a specific currency.
In this article, you’ll find out how to add a currency to a range of cells. You’ll also find out how to change the default currency that is used.
When you want to change the properties of data entered into a spreadsheet. You need to remember that you’re only changing the properties for the cells you’ve selected.
HOW TO USE CURRENCY OR CHANGE THE DEFAULT CURRENCY IN GOOGLE SHEETS
Time needed: 2 minutes.
This guide will show you how to add currency to a set of cells in Google Sheets. It will also show you how to change the default currency that is used.
- Highlight the selected cells
You need to highlight the selected cells where you want to add or change the currency.
- Choose the Format menu in Google Sheets
Whilst you have the cells highlighted use the mouse to click on the format menu at the top of your screen.
- Choose the Number sub menu
From the format menu, you want to choose the Number menu. You can do this by hovering or left-clicking with your mouse.
- Change your selected cells to a currency
The ‘number’ menu gives you the option to change the selected cells to a currency. Choosing this option will change the numbers in your selected cells to show the currency symbol in each cell. You’ll notice the currency will default to your local currency.
Below you can see it has defaulted to British Pound Sterling.
- Change the cells to show a rounded currency
The above step will change your numbers to the selected currency. It will also show the first two numbers to the right of the decimal place. If you only want to show rounded numbers, you can do this by clicking on the ‘Currency (rounded)’ option.
- Change to another currency
If you want to use a currency other than the default currency, you can do this from the same menu. Click on the format menu and then hover over the ‘number’ submenu FORMAT>NUMBER and choose ‘More Formats’ from the bottom of the menu.
- Choose more currencies
Once you’ve clicked on ‘More Formats’ choose ‘More Currencies’ from the submenu as shown below.
- Choose from the list of currencies
You’ll then be presented with a dialogue box, which shows a list of currencies. You can scroll up or down the list to find the currency. However, you can quickly find the currency by typing it into the search box at the top, as shown below.
You should now be able to easily change numbers in Google Sheets to a currency value. You’ve also learned how to change the default currency in Google Sheets.