Home Web AppsGoogle Sheets How to add or change the currency in Google Sheets

How to add or change the currency in Google Sheets

by Dan Millward

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.

  1. Highlight the selected cells

    You need to highlight the selected cells where you want to add or change the currency.
    highlight cells in Google Sheets

  2. 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.
    The format menu in Google Sheets

  3. 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.
    How to select the number menu in Google Sheets

  4. 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.

    How to change selected cells to a currency in Google Sheets

  5. 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.
    How to use rounded currency in Google Sheets

  6. 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.
    Click on more formats to find more currencies in Google Sheets

  7. Choose more currencies

    Once you’ve clicked on ‘More Formats’ choose ‘More Currencies’ from the submenu as shown below.
    More currencies menu in Google Sheets

  8. 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.
    List of currencies in Google Sheets

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.

Related Articles