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).
Hash Sign 
