Excel Number Format Shortcut: Quick Keys and Examples

In Excel for Microsoft 365 on Windows, select the cells and press Ctrl+Shift+! to apply the Number format, which displays values with two decimal places and a thousands separator. For other common formats, use Ctrl+Shift+$ for Currency, Ctrl+Shift+% for Percentage, or Ctrl+1 to open Format Cells and choose a format yourself.

What the number format shortcut does

A number format changes how Excel displays a cell’s value; it normally does not change the value stored in the cell. For instance, if a cell contains 1250.5, applying the Number format displays 1,250.50. The underlying value remains 1250.5, so calculations that refer to the cell continue to use that value.

The standard Number shortcut is useful when you want a consistent display for amounts, counts, or measurements. It adds two decimal places and a thousands separator, and shows negative values with a minus sign. The exact separator symbols can depend on your regional settings: in some locations a comma separates thousands and a period marks decimals, while other settings use the reverse.

Formatting is different from rounding or converting a value. A cell that displays 1,250.50 may still contain additional decimal places, and a formula can use those unshown digits. To change the actual value, you would need to round it in a formula or otherwise edit the value, rather than just apply a display format.

Common Excel number-format shortcuts

These Windows shortcuts apply a built-in format to the selected cells. Hold the listed modifier keys together, then press the punctuation key. Some symbols require the Shift key on a particular keyboard layout, so the physical keystroke can vary.

Ctrl+Shift+! applies Number format: two decimal places, a thousands separator, and a minus sign for negative values.
Ctrl+Shift+$ applies Currency format with two decimal places. The currency symbol and separators follow regional settings; negative values are commonly shown in parentheses.
Ctrl+Shift+% applies Percentage format with no decimal places.
Ctrl+Shift+^ applies Scientific format with two decimal places, such as 1.23E+05.
Ctrl+Shift+# applies a date display in the form d-mmm-yy, such as 2-Nov-26.
Ctrl+Shift+@ applies a time display in the form h:mm AM/PM.
Ctrl+Shift+~ applies General format, Excel’s default display format.

These shortcuts set a format; they do not insert a currency symbol or turn text into a numeric value. They are most reliable when the selected cells already contain numbers or dates that Excel recognizes as values.

How to apply a format step by step

To apply the standard Number format to one cell or a range in Excel for Microsoft 365 on Windows:

Select the cell, cells, row, or column you want to format. To select a range, drag across it or select the first cell and Shift-click the last.
Press Ctrl+Shift+!. Excel applies Number format immediately.
Check the result. If the display needs a different number of decimal places or another style, use the Home ribbon or open Format Cells.

The shortcut affects the current selection, so confirm that you have selected the intended cells before using it. To format a whole column, click its column letter first. To format non-adjacent ranges, hold Ctrl while selecting each range, then apply the shortcut once.

On Excel for Mac, the equivalent number-format shortcut is generally Control+Shift+!; other common format shortcuts use Control in place of Windows Ctrl. Keyboard layouts and macOS settings can affect punctuation shortcuts. For a reliable menu-based method, select the cells and use Home > Number, then choose a format from the number-format list. In Excel for the web, the ribbon route is also available; keyboard shortcuts can vary with the browser and keyboard settings.

Adjust decimal places and other details

The Number shortcut uses two decimal places, but that is only a starting point. On the Home tab, the Number group has Increase Decimal and Decrease Decimal buttons, which change how many decimal places are displayed. They do not necessarily round the stored value; they change its visible precision.

For more control, select the cells and press Ctrl+1 on Windows to open the Format Cells dialog. Choose the Number category, then set Decimal places, whether to use a thousands separator, and how negative numbers should appear. You can also choose categories such as Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, and Custom. On Mac, Command+1 opens Format Cells in current Excel versions; if a keyboard setting intercepts the shortcut, use the Home ribbon.

Custom formats are useful when a standard category is close but not quite right. For example, a custom format can show a number with one decimal place, display a unit after the value, or use different display patterns for positive and negative numbers. In Format Cells, choose Custom and select or enter a format code. A format such as 0.0 displays one decimal place, while 0.00 displays two. Custom formatting changes appearance, not the numeric value or the result of calculations.

Choosing the right format for the data

Choose a format based on what the value represents, not just how it looks in a sample cell. A percentage, date, monetary amount, and product code can all contain digits, but displaying them with the wrong format can mislead readers or make data difficult to interpret.

Use Number for quantities where decimals and separators improve readability, such as 12,500.00 units. Adjust the decimal places if two places suggest more precision than the data supports.
Use Currency or Accounting for monetary values. Currency places the symbol close to the amount; Accounting aligns currency symbols and decimal points within a column.
Use Percentage when the stored value is a proportion. A stored value of 0.25 displays as 25% with the percentage format.
Use Date or Time when the cell contains an Excel date or time value and you want a readable calendar or clock display.
Use Text for identifiers that should not be treated as quantities, such as ZIP codes or product numbers with leading zeros.

Percentage formatting is a common source of surprise. Applying it to 25 displays 2,500%, because Excel interprets the stored value as 25 and percentage display scales it by 100. If you mean 25%, the stored value should generally be 0.25. Conversely, formatting 0.25 as a percentage displays 25% without changing the underlying value.

Why the shortcut may seem not to work

If the display does not change as expected, first check the selected cells and the value type. A number stored as text may not respond like a numeric value. Text can result from importing data, entering a leading apostrophe, or pasting values with incompatible separators. A green error indicator may offer a Convert to Number option; alternatively, correct the source data or use Excel’s conversion tools before formatting.

Other common causes include:

The cell is already formatted similarly. Applying Number format again may appear to do nothing if the display already has two decimal places and a separator.
The shortcut key is different on your layout. Punctuation such as !, $, and # may require a different physical key combination outside a US keyboard layout. Try the Home > Number menu instead.
The cell contains a formula returning text. A formula that returns text will not become a numeric result just because you apply a number format.
The column is too narrow. Excel may show hash marks for some numeric or date displays. Widen the column or use Home > Format > AutoFit Column Width.
The number is too large or too small for the chosen display. Adjust the column width or select a more suitable number format.

If dates appear as serial numbers after applying General format, that does not necessarily mean the date has been lost. Excel stores dates as serial values and uses formatting to display them as calendar dates. Reapply a date format to show the value in a familiar form.

Number format versus changing a value

It is important to distinguish display formatting from the value itself. Suppose a cell contains 3.4567 and is formatted to show two decimal places. It displays 3.46, but calculations can still use 3.4567. If you need calculations to use a rounded amount, a display format alone is not enough; use an appropriate rounding formula or change the source value.

The reverse issue appears with identifiers. A value such as 00127 may be interpreted as the number 127, causing the leading zeros to disappear under General format. If the zeros are part of an identifier rather than a numeric quantity, store the entry as text or apply a suitable custom display format. Decide based on how the data will be sorted, matched, exported, and used in formulas.

Similarly, changing a cell to Currency does not perform a currency conversion. It only changes the symbol and display style. A dollar symbol does not prove that the number represents US dollars, and choosing another currency symbol does not calculate an exchange rate. Confirm the meaning and currency of source data separately.

Frequently Asked Questions

What is the shortcut for Number format in Excel?

In Excel for Microsoft 365 on Windows, select the cells and press Ctrl+Shift+!. It applies Number format with two decimal places and a thousands separator. On Mac, use Control+Shift+! where supported, or choose a format from Home > Number.

What is the shortcut to open Format Cells?

Press Ctrl+1 on Windows to open the Format Cells dialog. In current Excel for Mac versions, use Command+1. The dialog lets you choose a category and set details such as decimal places, symbols, and negative-number appearance.

How do I format a number with two decimal places?

Select the cells and press Ctrl+Shift+! on Windows. For a different number of decimal places, use the Increase Decimal or Decrease Decimal buttons in Home > Number, or set the value in Format Cells > Number.

Does applying Number format round the value?

No. It changes the displayed precision, not the value stored in the cell. A value with more than two decimal places can still retain those digits even when the cell displays only two.

Why does Percentage format multiply my number?

Percentage format displays a proportion as a percentage by scaling its display by 100. A stored value of 0.25 appears as 25%; a stored value of 25 appears as 2,500%. Enter or convert the underlying value appropriately before applying the format.

Quick takeaway

For the standard Excel Number format, select the cells and press Ctrl+Shift+! on Windows. Use Ctrl+1 when you need to customize decimal places, separators, or negative values. Remember that formatting controls appearance: it does not, by itself, round, convert, or otherwise change the cell’s stored value.

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.