Lesson 2.3 – Number Formats

Lesson 2.3 – Number Format

Number formats control how Excel displays numeric values such as currency, percentages, dates, and measurements. Formatting does not change the underlying value — it only changes how the value appears. Understanding number formats is essential for creating clear, professional spreadsheets.

---

1. What Number Formats Do

Excel stores numbers as raw values (e.g., 1500), but you can display them in different ways:

• 1,500 → with thousand separators
• $1,500.00 → as currency
• 1500% → as a percentage
• 15/03/2024 → as a date

The value stays the same — only the appearance changes.

---

2. Accessing Number Formats

You can apply number formats from:

• Home → Number group
• Right-click → Format Cells

The Format Cells window provides the most complete set of options.

---

3. Common Number Formats

3.1 General

The default format. Excel displays the number in the simplest way possible.

3.2 Number

Used for standard numeric values. Options include:

• Decimal places
• Thousand separators
• Negative number display

3.3 Currency

Displays values with a currency symbol (€, $, £). Example: €1,250.00

Use this format for prices, budgets, and financial data.

3.4 Accounting

Similar to Currency but aligns symbols and decimals neatly in columns. Ideal for financial reports.

3.5 Percentage

Converts the value into a percentage. Example: entering 0.25 → displays 25%.

Use this for ratios, growth rates, and statistics.

3.6 Date

Displays numeric values as dates. Example: 45200 → 15/10/2023

Excel supports multiple international date formats.

3.7 Time

Displays numeric values as hours, minutes, and seconds. Example: 0.5 → 12:00

3.8 Text

Forces Excel to treat the value as text. Useful for product codes, IDs, and values with leading zeros.

---

4. Custom Number Formats

Custom formats allow you to control exactly how numbers appear. Examples:

• 0.00 → always show two decimals
• #,##0 → thousand separators, no decimals
• €#,##0.00 → custom currency format

Custom formats do not change the underlying value.

---

5. Common Mistakes to Avoid

• Using text format for numbers → formulas will not work
• Mixing date formats in the same column
• Typing symbols manually (€, %, ,) instead of using formats
• Confusing “Currency” with “Accounting”

---

6. Practical Exercise

Practice number formats by completing the following steps:

1. Create a worksheet named Lesson_2_3_Practice.
2. Enter five numeric values in column A.
3. Apply the Number format with two decimals.
4. Convert the same values to Currency in column B.
5. Convert the same values to Percentage in column C.
6. Enter five dates in column D and apply different date formats.
7. Apply a custom format to display numbers as €#,##0.00.

---

Next Lesson

Lesson 2.4 – AutoFill and Flash Fill