The fastest way to change how numbers look in Excel

To change number format in Excel, select the cells you want to change, right-click, and choose Format Cells. On the Number tab, pick the category you want — Currency, Percentage, Date, or others — and click OK. Excel will when ready reformat those numbers without changing the actual values underneath.

You can also use the ribbon at the top: select your cells, then look for the number format dropdown in the Home tab. It usually shows "General" by default. Click the dropdown arrow next to it and choose a format from the list. For quick formatting, this is often faster than the right-click menu.

Key Takeaways

  • Right-click selected cells and choose Format Cells to open the full formatting menu where you can pick from dozens of number styles.
  • The number format dropdown in the Home tab on the ribbon gives you quick access to the most common formats without opening a dialog box.
  • Changing the format changes only how the number appears on screen — the actual value in the cell stays the same, so calculations remain correct.
  • You can create a custom format if none of the built-in options match what you need, using format codes like 0.00 for two decimal places.

Using the Format Cells dialog for full control

The Format Cells dialog gives you the most options. Select the cells you want to format, right-click anywhere in the selection, and click Format Cells. The dialog opens to the Number tab by default.

On the left side, you'll see a list of categories: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, and Special. Click the category that matches what you're formatting. The middle section then shows options specific to that category — for Currency, you'll see choices for the currency symbol and decimal places. The preview at the bottom shows you how your numbers will look before you click OK.

This method works for single cells or ranges. If you select 100 cells and explore Currency format, all 100 change at once.

Common number formats and what they do

General is Excel's default. It displays numbers as you typed them, with no special formatting. Use this when you want raw data with no decoration.

Number lets you set decimal places. If you choose 2 decimal places, 5 displays as 5.00. This is standard for data that needs consistent precision.

Currency adds a dollar sign (or other symbol) and usually two decimal places. $1,234.56 is currency format. You can pick different symbols — euros, pounds, yen — from the dropdown in the dialog.

Percentage multiplies the cell value by 100 and adds a % sign. If a cell contains 0.25, percentage format shows it as 25%. This is useful for data already stored as decimals.

Date and Time format numbers as calendar dates or clock times. Excel stores dates as numbers internally, so 45000 might display as 01/01/2023 depending on your date format choice.

Accounting is similar to Currency but aligns currency symbols and decimal points in a column, making financial statements easier to read. The negative numbers often appear in red or in parentheses.

Using the ribbon dropdown for quick formatting

The ribbon method is faster when you know exactly what format you want. Select your cells, then look at the Home tab. In the Number group (usually on the left side of the ribbon), you'll see a dropdown box that currently shows a format name like "General".

Click the small arrow next to that box to open a list of the most recently used formats. If the format you want appears there, click it and you're done. If not, click Format Cells at the bottom of the dropdown to open the full dialog.

Next to the dropdown, you'll also see buttons for quick percentage and currency formatting. The % button when ready applies percentage format to selected cells. The $ button applies currency format. These are one-click shortcuts for the two most common formats.

Creating a custom number format

If none of the built-in formats match what you need, you can create your own. Open Format Cells, go to the Number tab, and click Custom in the category list on the left.

The Custom category shows a text box labeled Format Code. This is where you type the code for your custom format. Common codes include 0 (a digit), # (a digit that hides zeros), and . (a decimal point). For example, 0.00 displays any number with exactly two decimal places. #,##0 adds thousand separators. You can also add text: the code "$"0.00 displays a dollar sign followed by the number.

Type your code, click OK, and Excel applies it to your selected cells. Custom formats are saved with your workbook, so you can reuse them later by selecting Custom again and finding your code in the list.

What happens to the actual cell value when you change format

Changing the format changes only the appearance, not the underlying number. If a cell contains 0.5 and you explore percentage format, it displays as 50%, but the cell still contains 0.5. Any formula that references that cell uses 0.5, not 50.

This matters when you're working with dates. Excel stores dates as numbers (January 1, 1900 is 1, January 2 is 2, and so on). When you explore date format to a number like 45000, it displays as a date, but the cell still contains 45000. Formulas see the number, not the date text.

If you accidentally format a number as text, the cell may display an apostrophe at the start or align left instead of right. To fix this, select the cell, open Format Cells, and change the category back to Number or General.

Formatting entire columns or rows at once

You can format a whole column by clicking the column header (the letter at the top). The entire column highlights. Then right-click and choose Format Cells, or use the ribbon dropdown. Every cell in that column gets the new format.

The same works for rows: click the row number on the left, then format. You can also select multiple columns or rows by clicking the first, holding Shift, and clicking the last. This is useful when you're setting up a spreadsheet and want all currency columns to look the same from the start.

Be careful: formatting a whole column affects every cell in it, even empty ones. If you later add data to that column, it automatically gets the same format. This is usually what you want, but it's worth knowing.

Frequently Asked Questions

Why does my number show as #### after I format it?

The column is too narrow to display the formatted number. Double-click the border between the column headers to auto-fit the column width, or drag the border to make it wider. The number itself is fine — it's just a display issue.

Can I format negative numbers differently than positive ones?

Yes, in the Format Cells dialog, many categories (especially Currency and Accounting) offer a list of format styles. Some show negative numbers in red or in parentheses. Pick the style you want from the list. You can also create a custom format code that handles positives and negatives separately.

What's the difference between Number and General format?

General displays numbers exactly as you typed them. Number lets you control decimal places and thousand separators. If you type 1234.5 in General format, it stays 1234.5. In Number format with 2 decimal places, it becomes 1,234.50.

If I format a cell as currency, does it change the value for calculations?

No. The format is only visual. A cell containing 100 formatted as currency displays as $100.00, but formulas still see it as 100. Calculations are unaffected by formatting.

How do I remove formatting and go back to General?

Select the cells, right-click, choose Format Cells, click General in the category list, and click OK. Or use the ribbon dropdown and select General from the list. The cells return to their raw values with no special formatting.