Formatting Numbers, Currency & Percentages
Learn how number formatting changes how values look without altering their raw values. Display clean currency symbols ($), percentages (%), and decimal points.
Why This Feature Matters
Entering raw numbers like 0.15 or 2450.5 can look confusing in a financial presentation. A client or manager wants to see clean figures formatted as 15% or $2,450.50.
Number formatting is like changing the "clothes" a number wears. It changes how a number is displayed on screen without altering the real underlying number used in formulas.
Common Number Format Types
Here are the standard format types used in business workbooks:
| Format Type | Raw Value in Cell | Displayed Look | When to Use |
|---|---|---|---|
| Currency / Accounting | 2450.5 |
$2,450.50 |
Sales, costs, budget reports, and customer invoices. |
| Percentage | 0.15 |
15.0% |
Discounts, tax rates, growth rates, and profit margins. |
| Comma Style | 1000000 |
1,000,000 |
Quantities, inventory counts, and visitor metrics. |
Step-by-Step Practice Guide
Practice calculating commercial orders with discounts and tax percentages:
Practice 1 — Enterprise Server Gross Total
In cell F2, calculate Gross Total by multiplying Unit Cost (B2) by Order Qty (C2).
=B2*C2In cell F2, calculate the Gross Subtotal for Enterprise Server by multiplying Unit Cost (B2) by Order Qty (C2). Formula: =B2*C2.
Practice 2 — Network Switch with 15% Discount
In cell F3, calculate Net Total after subtracting the 15% discount rate in D3.
=(B3*C3)*(1-D3)In cell F3, calculate the Net Cost after applying the 15% discount in D3 to Gross Subtotal. Formula: =(B3*C3)*(1-D3).
Practice 3 — Security Gateway Tax Amount
In cell F4, calculate the exact dollar tax amount by multiplying Gross Total by Tax Rate in E4.
=(B4*C4)*E4In cell F4, calculate the Tax Amount on the gross order by multiplying Gross Subtotal by Tax Rate in E4. Formula: =(B4*C4)*E4.
Practice 4 — Fiber Cable Final Invoice Total
In cell F5, calculate the final payable total by subtracting 10% discount first, then adding 8% tax.
=(B5*C5*(1-D5))*(1+E5)In cell F5, calculate the Final Payable Amount applying both 10% discount and 8% tax. Formula: =(B5*C5*(1-D5))*(1+E5).
When you reduce decimal places to zero (e.g. displaying 12.8 as 13), Excel only changes the visual appearance on screen. The underlying math formula will still use 12.8 for 100% precision.
Share This Lesson
Spread the word with your peers and challenge your friends