19. Applying number formats (currency, percentage, date)

Applying Number Formats

Number formats in Excel help you display data in specific ways, such as currency, percentage, or date formats. Let’s learn how:

Steps to Apply Number Formats

  1. Step 1: Select the cell or range of cells you want to format.
  2. Step 2: Go to the Home tab in the toolbar.
  3. Step 3: Use the Number Format dropdown to choose a format like Currency, Percentage, or Date.

Interactive Example

  A B C
1 12345.67 0.75 2023-12-31
2 67890 0.25 2024-01-01

Select a cell, then choose a number format to apply it.

Comments