Written By Sophanith Dith
Last Updated May 27, 2026
Applies to Microsoft Excel 365 (Windows only)
Part of the Beginner Learning Path
Module 3 Formatting and Layout
Lesson 1 of 14
When you first enter numbers in Excel, they may not look the way you expect. A price might appear as 1500 instead of $1,500.00, a percentage might show as 0.25 instead of 25%, or a large number may be hard to read without commas. Learning how to format numbers in Excel helps you make your worksheet clearer, cleaner, and easier to understand.
Number formatting changes how a number looks in a cell. It does not usually change the actual number stored in Excel. This means you can show the same value as a currency amount, percentage, decimal number, or comma-separated number depending on what your worksheet needs.
In this beginner-friendly tutorial, you’ll learn how to apply common number formats, adjust decimal places, use currency and percentage formats, and avoid common mistakes that confuse many new Excel users.
Quick Answer:
To format numbers in Excel, first select the cells you want to format, go to the Home tab, use the Number Format drop-down in the Number group, and choose a format such as Number, Currency, Accounting, Percentage, or Comma Style. You can also press Ctrl + 1 to open more formatting options.
Quick Reference
Before going step by step, here is a simple overview of what number formatting can do. These are the main skills beginners should understand first.
- Use the Home tab → Number group to apply common number formats.
- Choose Number to show values with decimals and comma separators.
- Choose Currency or Accounting for money values.
- Choose Percentage to display decimal values like
0.25as25%. - Use Increase Decimal and Decrease Decimal to control decimal places.
- Press Ctrl + 1 to open the full Format Cells dialog box.
Once you understand these basic options, formatting numbers becomes much easier to apply in real worksheets.
What Number Formatting Means in Excel
Number formatting is one of the simplest ways to make a worksheet easier to read. It controls how numbers appear on the screen, especially when you are working with prices, totals, percentages, quantities, or financial values.
For beginners, the most important idea is this: formatting changes what you see, not usually the actual value stored in the cell. For example, the value 1500 can appear as 1,500, $1,500.00, or 1500.00, but Excel still stores the same number behind the scenes.
Number Formatting Does Not Usually Change the Actual Value
This is important because Excel uses the actual value for calculations. The format only changes what you see in the cell.
For example:
| Actual Value in Cell | Number Format Applied | What You See |
|---|---|---|
| 1500 | Number with comma | 1,500.00 |
| 1500 | Currency | $1,500.00 |
| 0.25 | Percentage | 25% |
| 1250.5 | Number with 1 decimal | 1,250.5 |
This table helps show why number formatting is useful. You can make numbers more meaningful without retyping or changing the data itself.
Beginner Tip:
If a number is used in a formula, Excel calculates from the actual value, not just the way it looks.
Why Number Formatting Matters
Clean number formatting makes your worksheet easier for others to understand. A sales report, budget sheet, invoice, or class score list becomes much clearer when numbers are displayed in the right format.
For example, compare these two versions:
| Unformatted | Formatted |
|---|---|
| 12500 | $12,500.00 |
| 0.15 | 15% |
| 3500 | 3,500 |
The formatted version is easier to scan and understand. This is especially helpful when your worksheet has many rows or columns of numbers.
If you are still learning how to select cells before formatting them, you can review the earlier lesson on selecting cells and ranges in Excel before continuing.
Before applying specific formats, it helps to know where Excel keeps the most common number formatting tools.
Where to Find Number Format Options in Excel
Excel places the most common number format tools on the Home tab. This makes them easy to access because number formatting is something you will use often when cleaning up worksheets.
Most beginners only need the Number group for everyday formatting. More advanced options are available in the Format Cells dialog box, but you do not need to start there for every task.
Use the Number Group on the Home Tab
The Number group is the main place to format numbers quickly. It includes a format drop-down, currency button, percentage button, comma style button, and decimal controls.
To find it:
- Select the cell or range that contains the numbers.
- Go to the Home tab.
- Look for the Number group.
- Use the Number Format drop-down or the nearby buttons.
The Number Format drop-down may show General by default. General means Excel is not applying a special number style yet.
Beginner Tip:
If you want to format several numbers at once, select the full range first. For example, select B2:B10 before applying a currency or percentage format.
Use the Format Cells Dialog Box for More Options
The Format Cells dialog box gives you more control over how numbers appear. It is helpful when you want to choose decimal places, negative number styles, currency symbols, or special formats.
To open the Format Cells dialog box:
- Select the cell or range you want to format.
- Press Ctrl + 1.
- In the Format Cells dialog box, select the Number tab.
- Choose a category such as Number, Currency, Accounting, or Percentage.
- Adjust the options.
- Select OK.
You can also open this dialog box from the small dialog box launcher in the Number group, but Ctrl + 1 is often faster.
Beginner Warning:
Make sure you are on the Number tab inside the Format Cells dialog box. The dialog box also has other tabs such as Alignment, Font, Border, Fill, and Protection.
Once you know where the tools are, the next step is learning the most common format you will use: the regular Number format.
How to Format Numbers in Excel Using the Number Format
The Number format is useful when you want regular values to look cleaner and more consistent. It is often used for quantities, scores, measurements, totals, and general numeric data.
This format lets you control decimal places and show comma separators for large numbers. It is one of the best starting points when you want to format cells as numbers in Excel instead of leaving them in the default General format.
Format Numbers from the Home Tab
The Home tab is the fastest way to apply a basic Excel number format. Use this method when you want a simple, clean number style without opening extra settings.
Follow these steps:
- Select the cells you want to format.
- Go to the Home tab.
- In the Number group, open the Number Format drop-down.
- Choose Number.
- Use Increase Decimal or Decrease Decimal if needed.
Excel will display the selected values using the Number format. Depending on your settings, this may show decimal places and make the numbers look more consistent.
For example, if you select values like 1500, 2450.5, and 3000, applying the Number format can make the list easier to compare.
Format Numbers from the Format Cells Dialog Box
The Format Cells dialog box gives you more control than the Home tab. Use it when you want to choose the exact number of decimal places or decide whether to use a thousands separator.
Follow these steps:
- Select the numbers you want to format.
- Press Ctrl + 1.
- Select the Number tab.
- Choose Number in the Category list.
- Set the number of Decimal places.
- Check Use 1000 Separator (,) if you want commas.
- Choose a negative number style if needed.
- Select OK.
For example, if your worksheet has sales amounts such as 1200, 3500, and 4250, you can use the thousands separator to display them as 1,200, 3,500, and 4,250.
Beginner Tip:
For whole numbers, set Decimal places to 0. For money or measurements, you may want 2 decimal places.
After regular numbers, one of the most common formatting needs is money. Excel includes two common formats for that: Currency and Accounting.
How to Format Currency and Accounting Numbers
Money values should be formatted clearly so readers can quickly recognize prices, costs, revenue, or budgets. Excel gives you both Currency and Accounting formats for this purpose.
Both formats can show currency symbols and decimal places. The difference is mainly how they align the symbol and the numbers in the cell.
Use Currency Format for Money Values
Currency format is useful for everyday money amounts. It places the currency symbol close to the number and usually shows two decimal places.
Follow these steps:
- Select the cells that contain money values.
- Go to the Home tab.
- Open the Number Format drop-down.
- Choose Currency.
For example, a value like 1500 may appear as $1,500.00 after you apply Currency format.
You can also use the currency button in the Number group if the default symbol is correct for your worksheet.
Beginner Warning:
Do not type the currency symbol manually into every cell unless necessary. It is usually better to enter the number only, then apply Currency format.
Use Accounting Format for Financial Reports
Accounting format is often used in budgets, financial summaries, and reports. It aligns currency symbols and decimal points neatly, which makes columns easier to read.
Follow these steps:
- Select the money values.
- Go to the Home tab.
- In the Number group, select the Accounting Number Format button, which looks like a currency symbol in the Number group.
- Choose the currency symbol if needed.
Accounting format is especially useful when you have a column of amounts and want the symbols and values to line up consistently.
Here is a simple comparison:
| Format | Best For | Example Display |
|---|---|---|
| Currency | Everyday money values | $1,500.00 |
| Accounting | Financial reports and aligned columns | $ 1,500.00 |
The exact spacing may depend on the column width, but the purpose is the same: Accounting format creates a cleaner report-style layout.
If your worksheet is already organized as a table, these formats can make your data easier to read. You can review how to create Excel tables if you want your formatted data to include filters, table styles, and structured organization.
Once money values are clear, percentages are another format beginners often need to understand carefully.
How to Format Percentages in Excel
Percentages can confuse beginners because Excel treats them as decimal values. For example, 0.25 is the same as 25%, but if you type 25 and then apply Percentage format, Excel may show 2500%.
That is why it is important to understand how Excel stores and displays percentages. The percentage format changes the appearance, but the actual value still matters.
Apply Percentage Format
Use Percentage format when your number represents a part of a whole, such as a discount rate, completion rate, tax rate, growth rate, or score percentage.
Follow these steps:
- Select the cells you want to format.
- Go to the Home tab.
- In the Number group, select the Percent Style button.
- Use Increase Decimal or Decrease Decimal if you need more or fewer decimal places.
For example:
| Entered Value | After Percentage Format |
|---|---|
| 0.25 | 25% |
| 0.5 | 50% |
| 0.075 | 7.5% |
This is the correct approach when your values are already entered as decimals.
Avoid the Common Percentage Mistake
A common beginner mistake is typing a whole number first and then applying Percentage format. This can create results that look wrong.
For example:
| Entered Value | After Percentage Format |
|---|---|
| 25 | 2500% |
| 50 | 5000% |
| 75 | 7500% |
This happens because Excel sees 25 as twenty-five whole units, not twenty-five percent. When Percentage format is applied, Excel multiplies the display by 100 and adds the percent sign.
Beginner Tip:
If you want 25%, type 25% directly or type 0.25 and then apply Percentage format.
Percentages often appear in formulas and summary reports, but formula logic belongs in a later module. If you are ready for calculations after formatting, see the lesson on basic formulas in Excel when you reach Module 4.
After percentages, another small but important skill is controlling how many decimal places appear in your worksheet.
How to Change Decimal Places
Decimal places control how many digits appear after the decimal point. This is useful when you want numbers to look consistent, especially in prices, measurements, percentages, averages, and reports.
Excel gives you quick buttons for increasing or decreasing decimal places. These buttons change the display, not the actual stored value in most cases.
Increase or Decrease Decimals from the Home Tab
The Home tab includes two decimal buttons in the Number group. They are useful when your numbers show too many or too few digits.
Follow these steps:
- Select the cells you want to adjust.
- Go to the Home tab.
- In the Number group, select Increase Decimal to show more decimal places.
- Select Decrease Decimal to show fewer decimal places.
For example, the value 12.5 can display as 12.50 if you increase the decimal places. The value 12.567 can display as 12.57 if you decrease it to two decimal places.
Beginner Warning:
Decreasing decimal places may make the displayed number look rounded. However, Excel may still keep the more precise value in the cell.
Choose Exact Decimal Places with Format Cells
If you want a specific number of decimal places, use the Format Cells dialog box. This is helpful when you want all numbers in a column to follow the same style.
Follow these steps:
- Select the numbers.
- Press Ctrl + 1.
- Choose the Number tab.
- Select a category such as Number, Currency, or Percentage.
- Set the Decimal places box.
- Select OK.
For example, if you are formatting prices, you may choose 2 decimal places. If you are formatting whole quantities, you may choose 0.
Decimal places help with precision, but large numbers also need another important formatting option: comma separators.
How to Add Commas to Large Numbers
Large numbers are easier to read when they include comma separators. For example, 1250000 is harder to scan than 1,250,000.
Excel can add commas automatically through Number format, Comma Style, or the Format Cells dialog box. This is useful for sales totals, population numbers, quantities, budgets, and reports.
Use Comma Style
The Comma Style button is a quick way to add thousands separators. It is located in the Number group on the Home tab.
Follow these steps:
- Select the cells with large numbers.
- Go to the Home tab.
- In the Number group, select Comma Style.
- Adjust decimal places if needed.
For example, 25000 may appear as 25,000.00 depending on the decimal setting. You can use Decrease Decimal if you want it to appear as 25,000.
Use the 1000 Separator Option
If you want more control, use the Format Cells dialog box. This lets you add commas and control decimal places at the same time.
Follow these steps:
- Select the number cells.
- Press Ctrl + 1.
- Select the Number tab.
- Choose Number.
- Check Use 1000 Separator (,).
- Set the decimal places.
- Select OK.
This method is especially helpful when you want large numbers to appear without currency symbols.
Beginner Tip:
Use comma separators for large numbers, but avoid adding them manually by typing commas into each cell. Let Excel handle the formatting.
Once your numbers look readable, it helps to know which format to choose for different worksheet situations.
Common Excel Number Formats and When to Use Them
Excel includes several number formats, and beginners often wonder which one is correct. The answer depends on what the number represents.
Choosing the right Excel number format makes your worksheet easier to understand. It also helps prevent confusion when someone else reads or uses your file.
Number Format Comparison
The table below summarizes the most common beginner-friendly formats. Use it as a quick decision guide when formatting your worksheet.
| Format | Use It For | Example |
|---|---|---|
| General | Default entry with no special formatting | 1500 |
| Number | Regular values, quantities, scores | 1,500.00 |
| Currency | Prices, costs, money amounts | $1,500.00 |
| Accounting | Budgets and financial reports | $ 1,500.00 |
| Percentage | Rates, discounts, completion values | 25% |
| Comma Style | Large numbers without currency symbols | 1,500 |
| Date | Calendar dates | 5/26/2026 |
For Microsoft’s official explanation of the different options, see this guide to available number formats in Excel.
Dates are included here only for context because they are another type of value formatting. A full explanation belongs in the next lesson on how to format dates in Excel.
Simple Real-World Example
Imagine you have a small sales worksheet with columns for product price, quantity sold, discount rate, and total sales. Each column needs a different format.
You might use:
- Currency for product price
- Number with no decimals for quantity sold
- Percentage for discount rate
- Currency or Accounting for total sales
This makes the worksheet easier to scan because each number type has a clear visual meaning.
Beginner Tip:
Format one column at a time. This reduces mistakes and helps you choose the correct format for each type of data.
After learning the main formats, it is helpful to understand what to do when a number does not format correctly.
Common Number Formatting Mistakes to Avoid
Number formatting is simple once you understand the basics, but a few common mistakes can make your worksheet confusing. These mistakes usually happen when beginners mix up the displayed format with the actual value.
The good news is that most formatting problems are easy to fix once you know what to look for.
Mistake 1: Typing Symbols Manually
Many beginners type symbols such as $, %, or commas directly into cells. Sometimes Excel understands this, but other times it can make data harder to clean, sort, or calculate later.
A better habit is to type the plain number first, then apply formatting.
For example:
- Type
1500. - Select the cell.
- Apply Currency format.
This is usually better than manually typing $1,500.00.
Mistake 2: Formatting the Wrong Cells
If you apply formatting and nothing seems to change, you may have selected the wrong cell or range. This is very common when working with larger worksheets.
Before applying a format:
- Click the first cell in the range.
- Drag or use Shift to select the full range.
- Confirm the selected cells are highlighted.
- Apply the number format.
If you need a refresher, the earlier lesson on how to select cells and ranges in Excel can help.
Mistake 3: Confusing Percentages
Percentages can look wrong if the original value is not entered correctly. Remember that 0.25 formatted as a percentage becomes 25%, while 25 formatted as a percentage becomes 2500%.
A safe beginner habit is:
- Type
25%if you mean twenty-five percent. - Type
0.25if you want Excel to store it as a decimal value and display it as25%.
Mistake 4: Numbers Stored as Text
Sometimes numbers imported from another source may behave like text. They may align differently, fail to calculate, or not respond correctly to number formatting. If the value is stored as text, changing the number format may not fix it. In that case, the data may need to be converted before formatting works correctly.
This lesson focuses on formatting, not data cleanup. If you later work with imported data, you can learn cleanup methods in lessons such as Text to Columns in Excel and Flash Fill in Excel.
Beginner Warning:
If a number does not change after applying a format, it may not be stored as a real number. Formatting alone may not fix that issue.
Now that you know the common mistakes, let’s look at a few shortcuts that can make number formatting faster.
Useful Keyboard Shortcuts for Number Formatting
Keyboard shortcuts are optional, but they can save time once you start formatting numbers often. Beginners do not need to memorize all of them immediately.
Start with Ctrl + 1, because it opens the Format Cells dialog box and works for many formatting tasks.
Helpful Number Formatting Shortcuts
The table below includes useful Windows shortcuts for Excel number formatting. You can keep using the Ribbon if shortcuts feel too fast at first.
| Shortcut | What It Does |
|---|---|
| Ctrl + 1 | Opens the Format Cells dialog box |
| Ctrl + Shift + 1 | Applies Number format with commas and two decimals |
| Ctrl + Shift + 4 | Applies Currency format |
| Ctrl + Shift + 5 | Applies Percentage format |
| Ctrl + Shift + 3 | Applies Date format |
Use these shortcuts after selecting the cells you want to format. If nothing is selected, Excel applies the shortcut only to the active cell.
Beginner Tip:
Learn one shortcut at a time. Ctrl + 1 is the most useful because it gives you access to many formatting choices in one place.
Before finishing, it is useful to practice the full skill in a simple worksheet example.
Quick Practice
Practice helps number formatting become natural. Use this short exercise to apply several formats in one small worksheet.
Open a blank workbook and save it as XcelTips_Practice.xlsx if you want to practice with a simple example file.
| Product | Price | Quantity | Discount |
|---|---|---|---|
| Notebook | 2.5 | 10 | 0.1 |
| Pen | 1.25 | 25 | 0.15 |
| Folder | 3 | 8 | 0.2 |
Then format the worksheet:
- Select the values in the Price column.
- Apply Currency format.
- Select the values in the Quantity column.
- Apply Number format with
0decimal places. - Select the values in the Discount column.
- Apply Percentage format.
- Adjust decimal places if needed.
Your worksheet should now be easier to read. Prices should look like money, quantities should look like whole numbers, and discounts should appear as percentages.
After trying the practice worksheet, you should have a clearer idea of how each number format changes the way your data appears. Before moving on, let’s review the most important points to remember.
Key Takeaways
Number formatting is a basic Excel skill that makes worksheets clearer and more professional. Here are the most important points to remember.
- Number formatting changes how a value appears, not usually the value Excel stores.
- Use the Home tab → Number group for quick formatting.
- Use Ctrl + 1 for more detailed formatting options.
- Use Number format for regular values and quantities.
- Use Currency or Accounting for money values.
- Use Percentage carefully, especially when working with decimal values.
- Use comma separators and decimal controls to make numbers easier to read.
- If a number does not format correctly, it may be stored as text or selected incorrectly.
These key points cover the basics, but beginners often have a few extra questions when numbers do not display as expected. The answers below address the most common issues you may run into while formatting numbers in Excel.
Frequently Asked Questions (FAQs)
How do I format numbers in Excel quickly?
Select the cells, go to the Home tab, open the Number Format drop-down in the Number group, and choose the format you need. You can also press Ctrl + 1 to open the Format Cells dialog box.
What is the difference between General and Number format in Excel?
General is Excel’s default format with no special number style. Number format gives you more control over decimal places, comma separators, and negative number display.
Does number formatting change the actual value in Excel?
Usually, no. Number formatting changes how the value appears in the cell. Excel normally keeps the actual value for calculations.
Why does 0.25 become 25% in Excel?
Excel stores percentages as decimal values. When you apply Percentage format to 0.25, Excel displays it as 25%.
Why does 25 become 2500% when I apply Percentage format?
Excel treats 25 as the whole number twenty-five. When Percentage format is applied, Excel displays it as 2500%. To show 25%, type 25% directly or enter 0.25 and apply Percentage format.
What is the best Excel number format for money?
Use Currency for everyday money values and Accounting for financial reports where you want symbols and decimal points to align neatly.
How do I add commas to numbers in Excel?
Select the numbers, go to the Home tab, and choose Comma Style in the Number group. You can also press Ctrl + 1, choose Number, and check Use 1000 Separator (,).
Once you understand these common questions, number formatting becomes much easier to use with confidence. Let’s wrap up with a quick reminder of why this skill matters in everyday Excel work.
Conclusion
Learning to format numbers in Excel is an important beginner skill because it makes your worksheets easier to read, understand, and share. Once you know how to apply Number, Currency, Accounting, Percentage, decimal, and comma formats, your data starts to look much more organized and professional.
The best way to learn is to practice on a small worksheet with prices, quantities, discounts, and totals. Try applying different formats and notice how the display changes while the actual values stay usable for calculations.
This lesson is part of the Beginner Learning Path, a structured series designed to help you learn Microsoft Excel step by step from the basics.
← Previous Lesson in Module 2
How to Create Drop Down Lists in Excel to Make Data Entry Easier
Next Lesson →
How to Format Date in Excel Correctly: Beginner’s Step-by-Step Guide