0
0
Excelspreadsheet~5 mins

Number formats (currency, percentage, date) in Excel - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
Number formats help you show numbers as money, percentages, or dates. This makes your data easier to understand and looks professional. You can change how numbers appear without changing their actual values.
When you want to show prices with a dollar sign and two decimals in a sales report
When you need to display test scores as percentages in a grade sheet
When you want to show dates in a calendar or schedule clearly
When you want to format financial data to match currency style for budgeting
When you want to convert decimal numbers to percent format for easier reading
Steps
Step 1: Select
- the cells you want to format
The selected cells are highlighted and ready for formatting
Step 2: Click
- Home tab on the ribbon
The Home tab options are visible
Step 3: Click
- Number Format dropdown in the Number group
A list of number format options appears
Step 4: Select
- Currency from the dropdown
Selected cells show numbers with a currency symbol and two decimals
Step 5: Repeat steps 3 and 4
- but select Percentage
Selected cells show numbers as percentages with a % sign
Step 6: Repeat steps 3 and 4
- but select Short Date or Long Date
Selected cells show numbers as dates in the chosen date style
Before vs After
Before
Cells show raw numbers like 1234.5, 0.85, or 44205
After
Cells show $1,234.50, 85%, or 3/15/21 depending on chosen format
Settings Reference
Number Format dropdown
📍 Home tab > Number group
Choose how numbers appear in cells
Default: General
More Number Formats
📍 Home tab > Number group > Number Format dropdown > More Number Formats
Customize number appearance beyond preset options
Default: Varies by format
Decimal places
📍 More Number Formats dialog > Number tab
Set how many digits show after the decimal point
Default: 2 for Currency and Percentage
Common Mistakes
Formatting numbers as text to add currency or percent signs
This stops Excel from recognizing them as numbers, breaking calculations
Use the Number Format dropdown to apply currency or percentage formats properly
Changing the cell value instead of formatting to show a date
Typing a date as text loses date functions and sorting ability
Enter the date as a number or date, then apply a date format
Summary
Number formats change how numbers look without changing their value
Use the Home tab's Number Format dropdown to pick currency, percentage, or date styles
Avoid typing symbols manually; use formatting to keep data usable for calculations