Apply Currency Format in Excel

The Currency format in Excel allows you to display numbers as currency values with symbols and decimal points. It is useful for financial data, budgets, invoices, and accounting.

How to Apply Currency Format

1. Select the cells containing the numbers you want to format
2. Go to the Home tab → Number group
3. Click the dropdown and choose Currency
4. Optionally, choose the desired currency symbol and decimal places
5. Keyboard shortcut: Ctrl + Shift + $ (Windows) to quickly apply Currency format

Tips & Best Practices

• Use Currency format to make financial data readable and standardized
• Always check the correct currency symbol based on your location
• Combine with conditional formatting for financial reports for better visualization

FAQ

Q: Can I change the currency symbol after applying the format?

Yes, select the cells and choose a different symbol from the Currency dropdown in the Number group.

Q: Does Currency format affect calculations?

No, it only changes the display. Calculations are done on the underlying numeric values.

Q: Can I apply Currency format to multiple sheets at once?

Yes, select multiple sheets and then apply the format to the desired cells.