How to Change (or Convert) Currency in Google Sheets
Fast navigation
In 4 simple methods, this guide will show you how to change currency in Google Sheets.
Streamlining your workflow is easy, especially when dealing with international finances or data.
So let’s dive in and change currency in Google Sheets!
Methods:
- Changing the Default Currency Setting
- Bulk Changing Currency in the Entire Spreadsheet
- Changing Currency for Specific Cells
- Using Custom Currency Format
Method 1: Changing the Default Currency Setting
Step 1: Open Your Google Sheet
Navigate to the Google Sheet where you want to change the currency.
%20Currency%20in%20Google%20Sheets/screenshot-of-a-google-sheet)
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-file){kind=icon}
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-settings-in-dropdown-menu){kind=icon}
Step 4: Switch to the General tab and Change Locale
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-general-tab-the-settings-window){kind=icon}
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-united-kingdom-as-the-desire-country){kind=icon}
Step 5: Click on “Save and Reload”
Click on Save and reload to apply the changes.
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-save-and-reload){kind=icon}
This action changes the default currency for new data entries to the currency of your chosen locale. You can see it in the toolbar.
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-pound-symbol-in-the-toolbar){kind=icon}
Finished!
Method 2: Bulk Changing Currency in the Entire Spreadsheet
Step 1: Select All Cells
Click on the rectangle at the top-left corner of your sheet (between the A column and the 1 row) to highlight all cells.
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-the-rectangle-at-the-top-left-corner-of-google-sheet){kind=icon}
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-the-format-in-the-top-menu){kind=icon}
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-the-number-in-dropdown-menu){kind=icon}
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-the-custom-currency){kind=icon}
Step 3: Choose Your Currency
In the Custom Currency window, select the desired currency from the list.
%20Currency%20in%20Google%20Sheets/screenshot-of-custom-currency-window)
Click Apply..
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-apply-in-custom-currency-window){kind=icon}
This will change the currency format for all selected cells to the new currency.
%20Currency%20in%20Google%20Sheets/red-rectangle-highlights-the-prices-in-column-b-c-d-and-e)
Finished!
Method 3: Changing Currency for Specific Cells
Step 1: Highlight Specific Cells
Click and drag to select the cells or columns you want to change. You can also hold down the Command (Mac) or Control (Windows) key to select multiple non-adjacent cells.
%20Currency%20in%20Google%20Sheets/red-rectangle-highlights-the-price-in-column-c)
Step 2: Format the Cells
Go to Format > Number > Custom currency.
%20Currency%20in%20Google%20Sheets/two-red-rectangles-respectively-highlights-format-and-number-and-a-red-arrow-pointing-to-custom-currency){kind=icon}
Select the desired currency and click Apply.
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-apply-button){kind=icon}
The currency will change in the selected cells.
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-rectangle-that-highlights-prices-in-pound){kind=icon}
Finished!
Method 4: Using Custom Currency Format
Step 1: Select the Cell
%20Currency%20in%20Google%20Sheets/red-arrow-pointing-to-a-cell){kind=icon}
%20Currency%20in%20Google%20Sheets/two-red-rectangles-respectively-highlights-format-and-number-and-a-red-arrow-pointing-to-custom-currency_1){kind=icon}
Step 3: Customize Your Currency
In the Custom Currency window, you can set how you want the currency to appear. You can include currency symbols, decimal places, and more.
%20Currency%20in%20Google%20Sheets/red-rectangle-that-highlights-the-customize-options-of-currency)
Click Apply to save your changes.
%20Currency%20in%20Google%20Sheets/a-red-arrow-pointing-to-pound-symbol-and-another-red-arrow-pointing-to-apply-button){kind=icon}
Changing the currency format in Google Sheets is a straightforward process, whether you're updating a single cell or an entire spreadsheet.
By following the steps outlined in this guide, you can efficiently manage and present your data in the currency format that best suits your needs.
Finished!
