Change Currency Format in Google Sheets: A Practical Guide

To change a cell’s currency format in Google Sheets, select the cell or range, then choose Format > Number > More currencies and pick the currency you want. For the sheet’s default currency, use File > Settings to change its locale; formatting changes how values appear, but does not convert one currency into another.

How currency formatting works

A spreadsheet cell can hold a numeric value and display it in a chosen format. Currency formatting adds a currency symbol and usually shows two decimal places, while leaving the underlying number available for calculations. For example, a cell containing the number 1250 can display as $1,250.00, €1,250.00, or another currency style. The displayed symbol alone does not tell Sheets to perform an exchange-rate calculation.

This distinction matters when a sheet contains budgets, invoices, or sales figures. If you change a number from a dollar display to a euro display, the value remains 1250; it does not become the amount of euros that 1,250 dollars would buy. To convert currencies, you need a separate exchange rate and calculation. Formatting is only the presentation layer.

Currency format is normally applied to selected cells. That means a single sheet can show different currencies in different columns—for example, a supplier’s original invoice amount in one column and a separately converted amount in another. Keep the currency clear in headings or notes when people might otherwise mistake one amount for another.

Apply a currency format to cells

In Google Sheets in a web browser, use these steps to choose a specific currency:

Select the cell, cells, or entire range you want to format. Drag across a range, click a column letter to select a column, or use the name box to go to a known range.
Open Format > Number > More currencies.
Search for or browse to the currency by name or symbol, select the appropriate result, and apply it.

The available choices and their display styles can vary. Check the currency’s full name, not just its symbol: the dollar sign, for instance, is used by multiple currencies. Choosing a named currency helps make the intended format more explicit. If your menu presents a currency option directly, it may apply the sheet’s default currency; use the more-currencies picker when you need a different one.

For a quick default format, select the cells and choose Format > Number > Currency. The toolbar also includes a currency-format control; its exact appearance can vary with the Sheets interface. The menu is the clearer route when you need to confirm which currency is being applied. The formatting applies to the selection, so verify that you have not accidentally included headings or unrelated cells.

Choose a currency for the spreadsheet

If most amounts in a spreadsheet use the same currency, set the spreadsheet’s locale to a country or region that uses it. Open File > Settings, review the General settings, change Locale, and save the settings. The locale helps determine default conventions such as currency, date display, and number separators. It is a spreadsheet-level setting, not a change limited to one selected column.

Locale is useful when creating a sheet for a particular region, but it is not always the right fix for a mixed-currency document. A sheet may need a United States locale for date conventions while also containing amounts in yen, pounds, or Canadian dollars. In that case, keep the appropriate locale and apply the specific currency format to the relevant ranges instead.

Before changing a locale in a shared or established spreadsheet, review existing dates and numbers. Regional conventions differ: a comma can be a decimal separator in one locale and a thousands separator in another. Locale changes can affect how values are displayed and how new entries are interpreted, so check important columns after saving. It does not update exchange rates or translate existing financial records.

Adjust decimal places and number appearance

Many currency displays use two decimal places, but that is not appropriate for every purpose. A report may need whole-dollar totals, while a rate or unit price may need more precision. After applying a currency format, use the decimal-place controls on the toolbar, when available, to add or remove displayed decimal places. You can also inspect Format > Number for available number-format choices.

Reducing displayed decimal places usually rounds the value shown; it does not round away the stored number. For example, a stored value of 18.756 may appear as $18.76 when shown to two places, while calculations can still use the more precise value. If a calculation itself must be rounded, formatting alone is insufficient: the calculation would need to be designed to round the result. For reporting, make clear whether figures are exact, rounded for display, or rounded before further calculations.

For more control over the appearance, open Format > Number > Custom number format. Custom formats can define details such as decimal places and how positive, negative, or zero values appear. The dialog shows the format being applied, so review the preview before confirming. Custom formatting changes display, not the number stored in the cell. If you need to preserve a recognized currency symbol and a particular negative-number style, test the format on a sample cell first.

Currency, number, and accounting-style displays

Currency format is a practical default for amounts because it shows a currency marker and decimal places. A plain number format may be preferable for quantities, exchange rates, or amounts whose currency is stated clearly in a column heading. For example, if a table is explicitly labeled “USD” and contains many values, using a number format can reduce repeated symbols; the trade-off is that the currency is less visible in each individual cell.

Spreadsheets may offer more than one currency-related display option, and labels can differ across interfaces. Some styles align symbols or handle negative values differently. Choose based on how readers will scan the table, and apply one consistent style to comparable values. Do not assume that a familiar-looking layout changes the meaning of a value: number display styles do not change units or convert currencies.

For a comparison of currencies, show the original amount and the converted amount in separate, labeled columns. Include the rate or date used for a conversion if that information matters to the reader. A lone currency symbol can be ambiguous, and a conversion can become outdated as rates change. Formatting cannot supply the missing context.

Common problems and how to fix them

The wrong symbol appears: Apply the required currency explicitly through Format > Number > More currencies, rather than relying on the locale’s default. Confirm the currency name in the picker, especially for currencies that share a symbol.
The cell does not change: Confirm that the intended cells are selected and that the value is numeric. Imported amounts that include symbols or separators as text may not respond like numbers. A value that is stored as text must be converted to a number before normal currency formatting can display it as an amount.
There are too many or too few decimals: Adjust the displayed decimal places after applying the currency style, or use a custom number format. Remember that changing displayed precision does not necessarily change the stored value.
Dates or separators look different after a settings change: Review the spreadsheet locale under File > Settings. If only one range needs another currency, format that range rather than changing the locale for the whole spreadsheet.
Some cells look inconsistent: Check for cells with different formats, text values, or copied formatting. Select the complete intended range and apply one consistent format. If a cell has an unexpected appearance, inspect its number format rather than judging by alignment alone.

One common misconception is that adding a currency symbol turns a number into a currency conversion. It does not. Another is that a visible symbol proves a cell contains a numeric value; a symbol may have been typed as part of text. If totals or other calculations fail, check whether the entries are numeric values and whether the ranges include the intended cells.

Keep formats clear when sharing a sheet

When collaborators use a spreadsheet, make the currency understandable without requiring them to infer it from a symbol. Label columns with a currency code or full name when ambiguity is possible, especially in an international workbook. For example, “Amount (CAD)” communicates more than a bare dollar sign. Use consistent decimal places and number styles for comparable figures so that readers can compare rows easily.

Formatting is shared with the spreadsheet, but collaborators may have different regional expectations. A reader’s local conventions do not automatically mean that a displayed amount has been converted for them. If the sheet is meant to report amounts in a specific currency, state that clearly in the heading or a note. For important records, preserve the original amount and currency alongside any converted figures and document how those figures were produced.

Frequently Asked Questions

How do I change the currency symbol in Google Sheets?
Select the cells, then choose Format > Number > More currencies and select the currency by name. This changes the display format for the selected cells, not the numeric amount.

How do I make dollars the default in Google Sheets?
Set the spreadsheet’s locale under File > Settings to a country or region whose default conventions you want. For a dollar currency in only some cells, apply that currency to those cells instead of changing the locale for the whole spreadsheet.

Does changing currency format convert the amount?
No. Currency formatting changes how a number appears; it does not calculate an exchange rate. Use a separate conversion calculation and an appropriate rate if you need an amount in another currency.

Can I show a currency without decimal places?
Yes. Apply the currency format, then reduce the displayed decimal places using the toolbar controls when available, or choose a suitable custom number format. The displayed rounding does not by itself remove precision from the stored value.

Why does currency formatting not work on an imported amount?
The imported entry may be text rather than a numeric value, particularly if it includes a typed currency symbol or separators that Sheets does not parse under the current locale. Convert or clean the entry into a numeric value, then apply the currency format.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.