Number Formats
Mastering Number Formats
Controlling How Excel Interprets and Displays Data
In Excel, the Format is like a pair of glasses—it changes how you see the number without changing the number itself. Selecting the correct format ensures your data makes sense to the reader and works correctly in formulas.
Essential Format Types
Percentage (%)
Multiplies the cell value by 100 and adds the % symbol.
Example: 0.25 → 25%
Currency ($)
Adds currency symbols and thousand separators (,).
Example: 45000 → $45,000.00
Date (D/M/Y)
Converts serial numbers into readable calendar dates.
Example: 45415 → 04-May-2024
The "Hidden" Truth About Dates
One of the biggest "Aha!" moments for students is learning that Excel sees dates as whole numbers.
Day 1 is January 1, 1900. Every day after that adds +1. This is why you can subtract two dates (e.g., Today - Yesterday) to find the number of days between them. If your date suddenly looks like a random five-digit number, don't panic! Just change the format back to Short Date.
🔢 Decimal Precision
In the "Number" group on the Home tab, you will find two critical buttons:
Increase Decimal and Decrease Decimal.
Use these to clean up your data. For financial reports, keep it to 2 decimals ($10.50). For high-level summaries, decrease to 0 decimals ($11) to reduce visual clutter.
💡 Skill Eco Pro-Tip: The Shortcut
Want to change formats without using the mouse? Press Ctrl + Shift + % for Percentage, or Ctrl + Shift + $ for Currency. It’s the fastest way to format large tables!