Switch Excel Number Format: Quick Steps and Fixes

To switch an Excel number format, select the cell or range, then choose Home > Number Format and pick a format such as General, Number, Currency, Percentage, or Short Date. For more options, open the Format Cells dialog with Ctrl+1 on Windows and choose a category on its Number tab; this changes how a value is displayed, not the value stored in the cell.

What switching a number format actually does

An Excel number format controls the appearance of a cell’s value. A number such as 0.25 can appear as 0.25, 25%, or $0.25 depending on its format, while the stored value remains 0.25. That distinction matters: applying Percentage does not multiply a value by 100 in the worksheet; Excel displays the underlying value as a percentage.

Formatting is useful for making data easier to read without changing its meaning or the calculations that use it. You might show a price with a currency symbol, display a date without its time component, or add thousands separators to a large number. If you need to change the underlying value—for example, convert text that looks like a number into a real number—formatting alone may not be enough.

Switch a format from the Home tab

For a common format, the ribbon is usually the quickest method in Excel for Microsoft 365 on Windows:

Select one cell or a range of cells. To select a whole column, click its column letter.
Open Home > Number Format, the dropdown in the Number group.
Choose the desired option, such as General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, or Text.
If you choose Number, adjust the displayed decimal places with Increase Decimal or Decrease Decimal in the Number group, as needed.

You can also use the small dialog launcher at the lower-right corner of the Number group to open Format Cells. In that dialog, the Number tab contains categories and settings such as decimal places, a thousands separator, and negative-number styles. The Sample area previews the selected format. Select OK to apply it, or Cancel to leave the cells unchanged.

Changing a format affects the selected cells only. If a column contains mixed formats, selecting the entire column and choosing one format applies it to all cells in that column, including blank cells. That can be convenient for a consistent data-entry area, but it may also overwrite intentional differences such as a date in one row and a note in another.

Useful Windows number-format shortcuts

On Windows desktop Excel, select the cells first, then use one of these shortcuts. The shortcuts apply built-in formats; they do not open a menu for choosing every possible variation.

Ctrl+Shift+~ applies the General format.
Ctrl+Shift+! applies Number with two decimal places, a thousands separator, and a minus sign for negative values.
Ctrl+Shift+$ applies Currency with two decimal places.
Ctrl+Shift+% applies Percentage with no decimal places.
Ctrl+Shift+# applies a date format, commonly shown as day, abbreviated month, and two-digit year.
Ctrl+Shift+@ applies a time format that includes hours, minutes, and an AM or PM indicator.
Ctrl+Shift+^ applies Scientific notation with two decimal places.

Shortcut behavior can be affected by the keyboard layout, and some key combinations are awkward on compact keyboards. If a shortcut does not work, use Home > Number Format or open Format Cells with Ctrl+1. On a Mac, use the Home tab’s number-format controls for the same reliable ribbon route; keyboard shortcuts can differ by Excel version and keyboard layout. In Excel for the web, the ribbon is also the clearest option because browser shortcuts may take precedence.

Choose a format that matches the data

The right format depends on what the value represents and how readers need to interpret it. A number format does not validate that the underlying data is appropriate, so check the source values as well as the appearance.

General: Use for ordinary values when you do not need a particular display. Excel may show large or very small values in scientific notation if they do not fit comfortably.
Number: Use for quantities and measurements. Choose decimal places and whether to show a thousands separator.
Currency or Accounting: Use for monetary values. Currency places the symbol near each value; Accounting aligns currency symbols and decimal points in a column.
Percentage: Use when the stored value is a fraction of 1. A stored 0.25 displays as 25%; a stored 25 displays as 2,500%.
Date or Time: Use for actual Excel date-and-time values. The format controls which parts are visible, not the date or time itself.
Text: Use when entries should be treated as text, such as identifiers with leading zeros. Applying Text after a number has already been entered does not necessarily restore zeros that Excel previously removed.

For example, account codes such as 00418 are usually identifiers, not quantities. If Excel has interpreted the entry as the number 418, a number format may be able to display leading zeros, but the underlying value is still 418. For an identifier that must remain text, import or enter it as text before Excel removes the leading zeros.

Create a custom number format

When the built-in choices do not show the value the way you need, use a custom format. Select the cells and open Format Cells with Ctrl+1 on Windows, then select Number > Custom. Choose an existing code to edit or type a new code in the Type box. Excel’s format codes describe how numbers, dates, and text appear; they do not change the cell’s stored value.

Examples include 0.00 to show two decimal places, #,##0 to show whole numbers with thousands separators, and 0% to display a percentage with no decimal places. The zero placeholder requires a digit, while the hash placeholder displays a digit only when needed. Thus, 0.00 shows 3 as 3.00, whereas a format with optional decimal places can omit unnecessary zeros.

Custom formats can have up to four sections separated by semicolons, for positive numbers, negative numbers, zero values, and text, in that order. This lets a report display negative values differently or show zero as a dash without replacing the underlying zero. Use the Format Cells preview and test the code on representative values; a custom format that looks right for one value may not suit dates, very large values, or text entries.

Formatting is not the same as converting data

A frequent source of confusion is that a number format changes presentation but generally leaves the underlying value alone. If a cell contains 45292 and you apply a date format, Excel may display a calendar date rather than 45292 because Excel stores dates as serial numbers. In the standard 1900 date system, 45292 represents January 1, 2024. The date display is a view of that serial value, not a conversion to a different kind of stored object.

The reverse can also happen: choosing General may reveal a serial number where a date had been displayed. That does not mean the date was deleted. It means the cell is showing the stored serial value in a general numeric style. Formatting a date value as Text is not a dependable way to create a permanent text date; if another system requires text, convert or export the data deliberately and verify the result.

Likewise, applying Number to a cell containing the text string 123 will not always turn it into the numeric value 123. Check for the green error indicator or use Excel’s Convert to Number option when it appears. If values arrive from a text file, review the import settings and data types before relying on their displayed format.

Why the format may not appear to change

If you select a format and see no visible difference, the cell may contain text rather than a number, the selected cells may not be the ones you intended, or the chosen format may not distinguish the current value. For example, displaying 1 as Number with zero decimal places can look the same as displaying it in General. Try a format that makes the difference obvious, such as Currency, and inspect the formula bar or the cell’s alignment and error indicators.

Other common causes include:

The column is too narrow: Excel may show hash marks for some numeric or date displays. Widen the column by dragging the boundary between column headings or double-clicking that boundary to fit the contents.
A leading apostrophe or imported text: An entry such as ‘0012 is stored as text. A numeric format cannot make text behave like a number in calculations.
Unexpected decimal places: Increase or decrease the displayed decimal places from the Home tab, or set them directly in Format Cells.
Formatting was applied to only part of the data: Check the selection and reapply the format to the full range. Also check for conditional formatting that may affect the appearance.
Formula results: A formula can return a number that is displayed according to the result cell’s format. Changing the formula is not usually necessary when only the display needs to change.

When diagnosing an issue, inspect a single problem cell first. Open Format Cells to see its category, and check whether the cell contains a real number, date serial, or text. Fixing the data type before applying a display format is often more reliable than repeatedly changing formats.

Excel for Mac and the web

The number-format controls are available in Excel for Mac and Excel for the web, although the layout and shortcut behavior can differ from Windows. In both, select the cells and use the Home tab’s number-format dropdown to choose a built-in option. The Format Cells dialog provides additional number and custom-format choices in desktop Excel; the exact controls can vary in the web interface.

If you share a workbook between Windows and Mac, the numeric value and common number formats are generally carried with the workbook, but local settings such as currency symbols and date conventions can influence how some formats appear. For a report that must display consistently for different readers, use an explicit format, test the workbook in the target environment, and avoid relying on ambiguous date entries such as 03/04/2026 when the intended order is unclear.

Frequently Asked Questions

How do I change Excel from General to Number? Select the cells, then choose Home > Number Format > Number. To set decimal places and the thousands separator precisely, open Format Cells with Ctrl+1 on Windows and choose Number.

How do I switch a number to a percentage in Excel? Select the cells and choose Percentage from Home > Number Format, or use Ctrl+Shift+% on Windows. Excel displays the stored value multiplied by 100 with a percent sign, so 0.25 appears as 25%.

Why does Excel show a number instead of a date? The cell may be formatted as General or Number, exposing the serial value used to store the date. Select the cell and choose Short Date or another date format. If the entry is text rather than a date value, changing the format alone may not fix it.

How do I keep leading zeros in Excel? For identifiers, format the cells as Text before entering or importing the values. If the values are numeric and only need a fixed-width display, a custom format such as 00000 can show 418 as 00418, but the underlying number remains 418.

Can I change the format without changing the value? Yes. Number formatting changes how Excel displays a value, not its stored value. This is useful for dates, percentages, currency, and decimal places, but it will not convert text to numbers or change the result of a calculation.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.