# How do I change the currency format in Google Sheets?

To change the currency format in Google Sheets, select the cells, click Format > Number > Custom currency, search for or pick the currency you want, and click Apply. To change the default currency for the whole file, click File > Settings, pick your country under Locale, and click Save settings. In a 12-tab ProfitDrawer bookkeeping spreadsheet, the currency symbol is set once on the Settings tab and every label follows it.

**Format selected cells (computer):**

1. Open the spreadsheet in Google Sheets.
2. Select the cells to format.
3. Click **Format > Number > Custom currency**.
4. Search the text box for a currency, or enter your own format.
5. Optional: use the dropdown in the input box to change properties such as the number of decimal places.
6. Click **Apply**.

**Change the file's default currency:**

1. Click **File > Settings**.
2. Under **General**, change **Locale** (and **Time zone** if needed).
3. Click **Save settings**.

Google says changing the locale changes the spreadsheet's default currency, along with date and number formatting, including which character is used as the decimal separator. That affects everyone who opens the file.

Formatting only changes how a number looks; it does not convert amounts between currencies.

In ProfitDrawer workbooks, labels and totals use the symbol typed in the Currency symbol box on Settings, so change it there rather than reformatting each tab.

- Source: [Format numbers in a spreadsheet: Google Docs Editors Help](https://support.google.com/docs/answer/56470)
- Updated: 2026-10-29
- Published: 2026-10-29
- Category: Google Sheets and Excel how-tos
- Canonical: https://profitdrawer.com/answers/how-do-i-change-the-currency-format-in-google-sheets.html
- Publisher: ProfitDrawer (https://profitdrawer.com)