MSK Institute • Shikohabad
Loading Page Content...
Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...
Connecting serverPlease wait...
💻 Practical Labs🚀 Free Demo📜 Verified Certificates
Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...
Number formatting changes how a number looks visually without altering its underlying numerical value. A cell displaying $1,500.00, 150000%, or 1.50E+03 may contain the exact same underlying raw number 1500. Applying correct number formatting ensures financial clarity and avoids misleading rounding errors.
The Home tab houses one-click formatting buttons:
$): Formats as monetary currency.%) (Ctrl + Shift + %): Multiplies the cell value by 100 and displays a percent sign (e.g., 0.25 displays as 25%).,): Inserts thousands commas (e.g., 14500 becomes 14,500.00).Both formats display monetary currency, but their layout differences are significant:
| Feature | Currency Format | Accounting Format |
|---|---|---|
| Currency Symbol Placement | Sits immediately adjacent to the first digit (e.g., $1,250.00). | Aligns flush to the far left edge of the cell, leaving digits aligned to the right. |
| Negative Numbers | Displayed with a minus sign -$100.00 or colored red. | Enclosed cleanly in accounting parentheses $ (100.00). |
| Zero Values | Displays as $0.00. | Displays cleanly as a dash ($ -), uncluttering financial statements! |
| Decimal Point Alignment | Variable if symbol is close. | Decimal points align mathematically down the entire column. |
Remember how Excel calculates percentages:
50% into a cell stores the decimal value 0.5 internally.50, and you click the % button, Excel multiplies by 100, resulting in 5000%!=Profit/Revenue, and then click the Percent Style button to format the resulting decimal.Ctrl + 1 > Custom)Excel allows custom format strings divided into 4 semicolon-separated sections:
$#,##0.00;($#,##0.00);"-";@ (Standard corporate accounting)[Green]+#,##0;[Red]-#,##0;"Zero" (Colors positive numbers green and negatives red)000-00-0000 (Formats 9 digits as a Social Security number)"USD " #,##0.00 (Prefixes custom currency labels)Continue learning with hands-on practice, examples, and exercises in the upcoming topic.
| Previous Lesson | Next Lesson |
|---|---|
| Cell Formatting (Fonts, Colors, Borders) | Adjusting Rows and Columns |
Test your understanding of this lesson with 5 questions. Each question has one correct answer.