How to format numbers as currency in Google Sheets
Learn how to format numbers as currency in Google Sheets using the toolbar, Format menu, and custom currency options.
Quick answer
Select the cells you want to format, then click Format in the menu bar, choose Number, and select Currency to apply the default dollar format. For other currencies or decimal styles, choose More Formats > More Currencies to pick a specific symbol, or use the Custom currency option for full control over decimals and symbol placement.
Steps at a glance
- Select the cell range containing your numbers
- Click Format in the menu bar
- Hover over Number to open the format list
- Click Currency for the default dollar format
- Choose More Formats > More Currencies for other symbols
- Adjust decimal places using the toolbar icons if needed
Summary
Google Sheets lets you display numbers with a currency symbol and consistent decimal places without retyping dollar signs into every cell. This keeps financial data readable and consistent, whether you're tracking a budget, invoice totals, or sales figures across a spreadsheet.
Step-by-step guide
Step 1
Select the cells to format
Click and drag to highlight the range of cells containing the numbers you want to display as currency. You can select a single column, a row, or any block of cells, including empty ones you plan to fill in later.
Step 2
Open the Format menu
Click Format in the menu bar at the top of the screen. A dropdown will appear with several formatting categories, including Number, Text, and Conditional formatting.
Step 3
Hover over Number and select Currency
In the dropdown, hover over Number to reveal a submenu of number formats. Click Currency to instantly apply the default format, which displays values with a dollar sign and two decimal places, such as $1,250.00.
Step 4
Use the toolbar shortcut for faster formatting
Instead of using the menu, you can click the dollar sign icon in the toolbar to apply the same default currency format to your selected cells in one click. This is the fastest option if you just need standard dollar formatting.
Step 5
Choose a different currency symbol if needed
If you need euros, pounds, yen, or another currency symbol, go back to Format > Number and click More Formats, then More Currencies. Search for the currency you want in the text box, select it, and click Apply to update the selected range.
Step 6
Adjust decimal places
Use the 'Increase decimal places' and 'Decrease decimal places' icons in the toolbar to control how many digits appear after the decimal point. This is useful when working with whole-dollar totals or precise per-unit pricing.
Step 7
Create a custom currency format for special cases
For formats not listed by default, click Format > Number > Custom currency. Enter your own pattern with the symbol, thousands separator, and decimal style you want, then click Apply to save it for the selected cells.
Why this matters
You're building a budget, invoice, or expense tracker and typing dollar signs into every cell manually. Formatting the range as currency once saves time, keeps decimals aligned, and makes totals look professional whenever new numbers are entered or the sheet is shared with a client or teammate.
Frequently asked questions
Can I format currency automatically as I type new numbers?
Yes. Once you apply currency formatting to a range of cells, any new number typed into those same cells will automatically display with the currency symbol and decimal places, even if the cell was previously empty.
How do I show currency without decimal places?
After applying the Currency format, click the 'Decrease decimal places' icon in the toolbar until the decimals disappear, or set up a custom currency format with zero digits after the decimal point.
Does currency formatting change the actual value in the cell?
No. Currency formatting only changes how the number is displayed. The underlying value stays the same, so formulas like SUM or AVERAGE referencing those cells still calculate correctly.
Can I combine currency formatting with conditional formatting rules?
Yes. You can format a range as currency first, then apply conditional formatting rules, such as highlighting values above a certain threshold, without affecting the currency display.
Create interactive demos like this one — free, no coding required.
Start for free →