Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to format a number as currency in Excel and Google Sheets
Excel & Google Sheets
=TEXT(B2,"$#,##0.00")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Amount | Formatted Amount |
| 1234.56 | |
| 7890.12 | |
| 345.67 |
=TEXT(B2,"$#,##0.00")→$0,##0.00
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the cell or range of cells containing the numbers you want to format as currency.
- 2Right-click the selected cells and choose 'Format Cells' in Excel or 'Format' > 'Number' > 'Currency' in Google Sheets.
- 3In Excel, under the 'Number' tab, select 'Currency' from the Category list and adjust the decimal places if needed. In Google Sheets, you can further customize the currency symbol and decimal places by clicking on 'More formats' > 'Custom number format'.
Tips
- Ensure your locale settings are correct to display the appropriate currency symbol and format.
- For more control over the formatting, use the TEXT function as shown in the examples.
- Remember that applying currency formatting does not change the underlying numeric value of the cell.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Can I change the currency symbol?
Yes, in Excel, you can change the currency symbol by modifying the regional settings of your computer. In Google Sheets, you can customize the currency symbol using the custom number format option.
What if I need to format multiple currencies in the same sheet?
You can apply different currency formats to separate cells or ranges by selecting them individually and setting the desired currency format.
Does currency formatting affect calculations?
No, currency formatting only changes the appearance of the number and does not alter its actual value, so it will not affect any calculations performed on the data.