Number Formatting
Number Formatting in Microsoft Excel is used to change the appearance of numbers without changing their actual value. Proper number formatting makes data easier to read, understand, and analyze.
Excel provides several built-in number formats such as Number, Currency, Accounting, Percentage, Date, Time, Fraction, and Scientific formats.
Why Use Number Formatting?
- Improve data readability.
- Display currency values correctly.
- Show percentages accurately.
- Format dates and times professionally.
- Present reports in a standardized format.
Location of Number Formatting Options
Home Tab → Number Group
The Number Group contains various formatting options used to format numeric data.
Common Number Formats
| Format Type | Description | Example |
|---|---|---|
| General | Default Excel format | 1250 |
| Number | Displays decimal values | 1,250.00 |
| Currency | Displays currency symbol | ₹1,250.00 |
| Accounting | Aligns currency symbols | ₹ 1,250.00 |
| Percentage | Multiplies value by 100 and adds % sign | 85% |
| Date | Displays date values | 05-Jun-2026 |
| Time | Displays time values | 10:30 AM |
Applying Number Formatting
- Select the cell or range of cells.
- Go to the Home tab.
- Locate the Number Group.
- Click the Number Format dropdown.
- Select the desired format.
Decimal Formatting
Excel allows users to increase or decrease the number of decimal places displayed.
| Original Value | Formatted Value |
|---|---|
| 1234.56789 | 1234.57 |
Use the Increase Decimal and Decrease Decimal buttons in the Number Group.
Currency Format
Currency formatting is used for financial data such as salaries, fees, sales amounts, and expenses.
| Value | Currency Format |
|---|---|
| 5000 | ₹5,000.00 |
Percentage Format
Percentage format is commonly used for marks, discounts, profit percentages, and growth calculations.
| Entered Value | Percentage Format |
|---|---|
| 0.85 | 85% |
Date Format
Date formatting is used to display dates in different styles.
| Original Date | Formatted Date |
|---|---|
| 05/06/2026 | 05-Jun-2026 |
Custom Number Format
Custom formats allow users to create their own display styles.
| Format Code | Example Output |
|---|---|
| 00000 | 00125 |
| #,##0 | 12,500 |
| 0% | 85% |
Shortcut Keys
| Shortcut Key | Function |
|---|---|
| Ctrl + Shift + $ | Apply Currency Format |
| Ctrl + Shift + % | Apply Percentage Format |
| Ctrl + Shift + # | Apply Date Format |
| Ctrl + 1 | Open Format Cells Dialog Box |
“`
