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
- Step 1: Select the cell or range of cells you want to format.
- Step 2: Go to the Home tab in the toolbar.
- 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
Post a Comment