If you manage monthly profits or department-wise financials in Excel, applying currency formatting is a must. Whether you’re tracking profits for Sales, Marketing, HR, or Finance, converting raw numbers into clean, readable currency values brings clarity and professionalism.
Table of Contents
✅ How to Apply Currency Format
🟢 Using the Excel Ribbon
- Select the cells (e.g., B2:D8) containing your monthly profits.
- Go to the Home tab.
- In the Number section, click the Currency (💵) dropdown.
- Select your desired currency (e.g., ₹ Rupee, $ Dollar, € Euro).