How to Change Currency Symbol in Google Sheets

When creating international invoices, expense reports, or multi-currency budget models in Google Sheets, numerical values often default to your account’s regional currency symbol (such as the British Pound £, US Dollar $, or Euro €). If you collaborate with overseas clients or track financial accounts denominated in different currencies, Google Sheets allows you to format individual cells or entire columns with specific global currency symbols without altering your system’s overall spreadsheet locale. Here is how to change currency symbols in Google Sheets.

Method 1: Using the More Currencies Formatting Menu

Google Sheets includes an extensive built-in catalogue of global currencies accessible directly from the toolbar:

  1. Open your spreadsheet in Google Sheets and highlight the cells, columns, or rows you wish to format.
  2. Click the 123 (More formats) button on the main toolbar (or navigate to Format > Number in the top menu bar).
  3. Hover your cursor over Custom currency at the bottom of the number formatting menu.
  4. In the Custom currencies dialogue box that opens, scroll through the alphabetical list or type your desired currency into the search field (such as “British Pound”, “Euro”, “Japanese Yen”, or “Australian Dollar”).
  5. Choose how you want the currency symbol displayed relative to the number (for example, whether the symbol appears before or after the digits, and whether to include decimals).
  6. Click Apply. The selected cells will update with the chosen currency formatting immediately.

Method 2: Changing the Entire Spreadsheet Locale

If your entire workbook is dedicated to a specific foreign market, changing the spreadsheet locale sets the primary toolbar currency button (the $ or £ shortcut icon) to match that country automatically:

  1. Click File in the top menu bar and select Settings.
  2. Ensure the General tab is selected.
  3. Under the Locale dropdown, select your target country (for example, United Kingdom for GBP, Germany or France for EUR, or United States for USD).
  4. Click Save and reload.
  5. Now, whenever you click the quick Format as currency button on the toolbar, Google Sheets will apply that country’s standard currency symbol, decimal separator, and date conventions by default.

Method 3: Creating Custom Currency Codes with Formatting Rules

For corporate accounting where three-letter ISO currency codes (like GBP 1,250.00 or USD 500.00) are preferred over symbols:

  1. Highlight your financial numbers.
  2. Go to Format > Number > Custom number format.
  3. In the text field at the top, type your desired formatting string, such as:

    "GBP " #,##0.00

  4. Click Apply. Numbers will retain full arithmetic calculability while displaying formal accounting abbreviations cleanly.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.