In Microsoft Excel for Microsoft 365 on Windows, open Format Cells by selecting a cell and pressing Ctrl+1, or use the dialog launcher in Home > Number. Choose a category such as Number, Date, or Text, adjust its options, and select OK. Formatting changes how a value looks; it usually does not change the value stored in the cell.
What Format Cells controls
Format Cells is Excel’s detailed control panel for the appearance and display of selected cells. It groups settings into tabs for Number, Alignment, Font, Border, Fill, and Protection. You can apply a format to one cell, a selected range, or several nonadjacent selections. The ribbon’s number-format buttons are convenient for common changes, while the dialog exposes more options.
A cell’s stored content and its displayed appearance are separate. A value such as 0.25 can be displayed as 0.25, 25%, or $0.25, depending on the number format. In each case, the underlying value remains 0.25, so formulas still use that value. Formatting is therefore useful for making a worksheet readable without changing the calculations.
Format Cells does not create rules that respond to the value. For example, a regular red font color stays red even if the cell’s value changes. To apply formatting automatically when a condition is met, use Home > Conditional Formatting instead.
How to open and use the dialog
On Windows, select the cells you want to change and press Ctrl+1. You can also select Home > Number and click the small dialog box launcher at the lower-right corner of that group. In some ribbon layouts, right-clicking a selection and choosing Format Cells is another route. The dialog contains tabs; choose one, set the options, and select OK to apply them.
For example, to show a decimal as a percentage, select the cells, open Format Cells, choose Percentage under Number, select the number of decimal places, and confirm. If the cell contains 0.25, a percentage format with no decimal places displays 25%. It does not multiply the stored value or change the result used by a formula.
- Use the Number tab for number, date, currency, percentage, text, and custom formats.
- Use Alignment to position content, wrap text, or control how text fits.
- Use Font, Border, and Fill to change type appearance, cell outlines, and background color.
- Use Protection to mark cells as locked or hidden; those settings take effect when worksheet protection is enabled.
In Excel for Mac, Command+1 opens Format Cells. The ribbon layout and some labels can differ from Windows; the Home tab and the Format Cells dialog provide the corresponding controls. Excel for the web has a more limited set of formatting controls than the desktop apps. Use the Home tab’s number-format controls for routine changes, and open the workbook in desktop Excel if a specific dialog option is unavailable.
Choosing number, date, and text formats
The Number tab is where many users spend the most time. Its categories control how Excel displays numeric values, and some categories reveal additional choices such as decimal places, a currency symbol, or a locale. Choose a format based on what the values mean, not just how you want them to look.
- Number: Displays values with a chosen number of decimal places and can add a thousands separator. It is a general choice for quantities, measurements, and counts that may include decimals.
- Currency and Accounting: Both display a currency symbol. Accounting format aligns symbols and decimal points in a column, which can make financial tables easier to scan. Currency format places the symbol closer to the value.
- Percentage: Displays a value as a proportion multiplied by 100 for presentation. A stored value of 0.08 appears as 8%. Applying the format to a stored value of 8 instead displays 800%, so check whether the original value is a decimal proportion or a whole-number percent.
- Date and Time: Display Excel date or time values in a selected pattern. A date can appear as 3/7/2026 or 7-Mar-2026 without changing the date represented.
- Text: Displays cell contents as text. It is useful for identifiers that should not be treated as quantities, such as codes with leading zeros, but changing an existing cell to Text does not automatically convert its current contents.
- General: Lets Excel choose a basic display. It is often suitable for initial entry, but may show long numbers in scientific notation or omit zeros after a decimal point.
Dates deserve particular care because Excel stores recognized dates as serial values and displays them according to a date format. A date that appears as a number may simply have been given a Number or General format; selecting a Date format can reveal it. Conversely, text that merely looks like a date may not behave like a real date in sorting or date calculations.
Alignment, fonts, borders, and fills
Format Cells also controls layout and visual hierarchy. In Alignment, horizontal and vertical positioning can make headings and figures easier to read. Wrap Text displays long cell contents across multiple lines within the column width. It can increase row height, so a row may look taller after wrapping is turned on. Orientation rotates text, while indentation shifts it within a cell.
The Font tab changes typeface, size, emphasis, and color. The Border tab adds outlines or internal lines to selected cells, and Fill sets a background color or pattern. These settings affect cell presentation rather than the values. Borders are often more useful for defining a table’s structure than filling every cell with a strong color, which can make dense worksheets harder to read.
A practical example is a monthly report: use a bold font for the header row, a bottom border to separate it from the data, and a consistent number format for the values below. Apply settings to the full relevant range when possible. That makes future entries more consistent, although formatting alone does not guarantee that newly added rows inherit the style in every worksheet layout.
Custom formats for specific displays
When the built-in categories do not provide the display you need, choose Custom on the Number tab and enter a format code. Custom formats change presentation, not the underlying data. For instance, the code 00000 can display the value 123 as 00123. The stored value remains 123, so this is appropriate only when the leading zeros are for display and the value is still meant to be numeric.
Another useful code is 0.00, which displays two decimal places. A value of 4.5 appears as 4.50, while its stored value remains 4.5. This can help align measurements in a report. If you need to preserve actual leading zeros as part of an identifier, such as a product code, storing the entry as text is usually more reliable than relying only on a display format.
Excel custom number formats can have sections separated by semicolons for positive numbers, negative numbers, zero, and text. This makes it possible to display negative values in parentheses or show a dash for zero while keeping the underlying number intact. Because custom codes can be confusing and may be interpreted differently across locales, check the preview in the dialog and test the format on representative values before applying it to a large range.
Formatting is not the same as changing data
A frequent misunderstanding is that a display format converts a value. Formatting a number as a date does not turn an arbitrary number into the date the user intended; it displays the number using Excel’s date system. Similarly, applying a currency format does not convert one currency into another or change a value’s purchasing power. It adds a visual symbol and number presentation.
Formatting as Text is also not a general-purpose conversion command. If a cell already contains a number, selecting Text afterward may change how it displays, but it does not necessarily make the existing content behave as text. To enter a new identifier with leading zeros, format the destination cells as Text before typing, or enter the identifier as text. For existing imported data, use an appropriate conversion method and verify the results rather than assuming the format change altered the stored content.
Cell formatting is also different from a table style or conditional formatting. A table style applies a coordinated design to an Excel table, while conditional formatting changes appearance when rules are met. Use Format Cells for fixed presentation, conditional formatting for value-driven highlighting, and a table style when you want a consistent table design that can extend as table data grows.
Common problems and how to fix them
- Dates appear as serial numbers: Select the cells and choose an appropriate Date format in Format Cells. If the values remain unchanged or do not sort as dates should, they may be text rather than recognized date values.
- Leading zeros disappear: Excel commonly treats an entry such as 00123 as a number and drops the zeros. For new entries, format the cells as Text before typing if the zeros are part of an identifier. A custom format such as
00000can display zeros for numeric values, but does not change their stored value. - A number shows as ####: The column may be too narrow to display the formatted value, especially for dates or larger numbers. Widen the column or choose a more compact format. The hashes generally indicate a display-width problem, not that the value has been erased.
- Decimal places seem wrong: Check both the stored value and the chosen format. Increasing displayed decimal places reveals more of the stored value; it does not add precision to the original data. Percentage formatting can also make a value appear one hundred times larger when the input was entered as a whole-number percent rather than a decimal proportion.
- Formatting will not go away: Select the affected cells and choose Home > Editing > Clear > Clear Formats on Windows. This removes formatting but keeps cell contents and formulas. It also removes formatting you may want to retain, so select only the necessary cells.
If the worksheet contains mixed formatting, select a representative cell and inspect Format Cells before changing a whole column. Applying a format to an entire range can make the display consistent, but it cannot correct mixed-up source values or repair formulas.
Frequently Asked Questions
What is the shortcut for Format Cells in Excel?
In Excel for Microsoft 365 on Windows, select the cells and press Ctrl+1. On Mac, use Command+1. The shortcut opens the formatting dialog, where you can choose a number format, alignment, font, border, fill, or protection setting.
How do I format cells as currency in Excel?
Select the cells, press Ctrl+1 on Windows, choose Currency on the Number tab, select the symbol and decimal places, and select OK. Accounting is an alternative when you want currency symbols and decimal points aligned across a column.
Why does Excel show a date as a number?
Excel stores recognized dates as serial values. If a cell is displayed as a number, select it and apply a Date format. If that does not produce the expected date, the entry may be text or may not represent the intended date value.
Does formatting a cell change its value?
Usually, no. Number formats, colors, borders, and alignment affect how content appears, while formulas use the stored value. Some actions that look like formatting, such as converting or replacing data, can change content, so distinguish those operations from the Format Cells settings.
How do I show leading zeros in Excel?
For a numeric value that only needs zeros for display, use a custom format such as 00000. If the zeros are part of a code or identifier, store the entry as text, ideally by formatting the cells as Text before entering the values.
Related
- Interpolate in Excel: Does Solver Help?
- Insert Row Shortcut in Excel on a Laptop
- Insert Row Shortcut in Excel and Repeat It Quickly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Remove a Page Break in Excel: Manual and AutomaticTo remove a manual page break in Excel for Microsoft 365 on Windows, select the cell immediately below…
- Excel Column Hide Shortcut Key: Windows and MacIn Excel for Microsoft 365 on Windows, select the column or columns you want to hide and press…
- Enter Serial Numbers in Excel: Manual and Automatic MethodsTo create a numbered list in Excel, enter 1 and 2 in the first two cells, select both,…
- Excel Data Validation List: Remove DuplicatesYes. In Excel for Microsoft 365, create a unique list from the original entries with =SORT(UNIQUE(FILTER(A2:A100,A2:A100<>""))), then use…
- How to Add Page Numbers in Word Starting on Page 4To add page numbers in Word starting on the fourth page, insert a Next Page section break at…
- Resize Columns in Excel: Keyboard Shortcuts That WorkTo resize a column to fit its contents in Excel for Microsoft 365 on Windows, select the column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.