How to Change Currency in Google Sheets
Formatting numbers as currency in Google Sheets is essential for financial spreadsheets. You can choose from built-in currencies or create custom formats.
Select Your Cells
Highlight the cells or columns that contain the numbers you want to format as currency.
Use the Format Menu
Go to Format > Number > Currency. Choose from the list of available currencies.
💡 The dollar sign ($) button in the toolbar applies your default currency.
Choose a Specific Currency
Click Format > Number > More Formats > More currencies. Search for your desired currency (USD, EUR, JPY, GBP, etc.) and click Apply.
Create a Custom Currency Format
Go to Format > Number > Custom number format. Enter a format like "$"#,##0.00 to create a custom currency display with two decimal places.
Try These Templates
Frequently Asked Questions
Does changing currency format affect calculations?
No. Currency format only changes how the number is displayed. The underlying value remains the same.
Can I use multiple currencies in one sheet?
Yes. Apply different currency formats to different cells or columns as needed.