If an Excel cell format is not changing, first check whether conditional formatting is overriding what you set; then check whether the value is stored as text, the sheet is protected, or the display is limited by column width. Select the cell and use Home > Number Format or press Ctrl+1 on Windows to inspect its format, then work through the checks below.
Start by checking the cell’s displayed formatting
Excel separates a cell’s underlying value from the way that value is displayed. A cell can contain the number 0.25 and display as 25%, or contain a date serial number and display as a calendar date. Changing the format changes the appearance; it usually does not change the underlying value. That distinction explains many cases where a format appears to do nothing.
Select the cell and look at the Number Format dropdown on the Home tab. If it says General, choose a suitable format such as Number, Currency, Percentage, or Short Date. For more control, open Format Cells with Ctrl+1 on Windows, choose the Number tab, select a category, and review the sample before clicking OK. On a Mac, Command+1 opens Format Cells. In Excel for the web, use the Home tab’s number-format controls; some detailed formatting options are easier to access in the desktop app.
If you are trying to change fill color, font, borders, or alignment rather than a number format, use the relevant controls in Home. Confirm that the intended cell is selected, especially if the sheet has merged cells or you selected a range that includes more cells than expected.
Check conditional formatting rules
Conditional formatting can make a cell look as though a manual format did not apply. For example, you set a cell’s fill to yellow, but a rule colors it red whenever its value is below 10. The rule’s appearance is displayed when its condition is true, so the manual fill may be hidden. Rules can also change font color, borders, number formats, or other visual properties.
- Select the affected cell or range.
- Go to Home > Conditional Formatting > Manage Rules.
- In the rules window, set the list to show rules for the current selection, or inspect the whole worksheet if needed.
- Check whether a rule applies to the cell and whether its condition is currently true. Edit, delete, or adjust the rule as appropriate.
Do not remove a rule just because it changes the appearance: it may be providing an important warning or highlighting pattern. If you want the manual format to show under different conditions, revise the rule or its Applies to range. Conditional formatting is also a common reason that a color change works in one cell but not in neighboring cells.
Find out whether the value is stored as text
Number formatting cannot turn text into a number. If a value such as 125 is stored as text, applying Currency or Number format may leave it looking unchanged. Text often arrives through a CSV import, a copied web table, or a system export. Clues include a green warning marker, left alignment when nearby numbers are right-aligned, or an apostrophe before the value in the formula bar. Alignment alone is not conclusive because users can set alignment manually.
To check, select the cell and look at the warning icon if one appears. Excel may offer Convert to Number. You can also try a simple test in an unused cell: with the suspected value in A1, enter =ISNUMBER(A1). TRUE means Excel recognizes the value as a number; FALSE means it does not. If the value is text, changing its display format alone will not fix the underlying data.
For a column of imported values, select the range and use Data > Text to Columns, then follow the wizard and finish the conversion. Check the preview and delimiter settings first so that the process does not split data unexpectedly. Another option is to use a helper column to convert values, then copy the results and use Paste Special > Values. Be careful with dates: ambiguous text such as 03/04/2026 can be interpreted differently depending on regional date settings. Confirm the intended month and day before converting a whole column.
Make sure the cell is not locked by sheet protection
A protected worksheet can prevent formatting changes. If commands are unavailable, or Excel reports that the cell or chart is on a protected sheet, check the Review tab for Unprotect Sheet. If the sheet is password-protected, you need the password or help from the workbook owner; do not assume that changing the cell’s style will bypass protection.
Protection settings can allow editing cell contents while disallowing formatting, so a cell that accepts typing may still reject format changes. The sheet owner can review Review > Protect Sheet and the permissions selected there. In Excel for the web, protection controls can differ from the desktop ribbon, but the same principle applies: a protected range may restrict the action even when the workbook opens normally.
Rule out column width and other display limits
Sometimes the format did change, but the result is hard to see or cannot fit in the cell. A narrow column can display ##### for many numeric values and dates. Widen the column by dragging the boundary between its column letters, or double-click that boundary to AutoFit. A long text value may appear cut off because the next cell contains data, even though its format is correct.
Some values also have limits that are not formatting errors. Excel does not display negative date or time values in the usual date system, so a negative result may appear as hash marks. A date format applied to a very large number can produce an unexpected date because Excel interprets numeric values as date serials. Likewise, a percentage format multiplies the displayed number by 100: a stored value of 0.25 displays as 25%, while a stored value of 25 displays as 2500%. Adjust the underlying value if that is not what you intended.
Look for table styles and cell styles
If the cell is part of an Excel table, its table style may be supplying banded rows, header colors, or other visual features. Select a table cell and inspect the Table Design tab, where you can review the selected style and options such as Header Row and Banded Rows. You can change the table style or turn off a relevant style option to see whether it is responsible for the appearance.
Excel also has named cell styles, such as Heading or Input. Applying a style changes a collection of formatting properties at once, while direct formatting can customize individual properties. To inspect or change a cell style, use Home > Cell Styles. If the workbook has a custom style that looks wrong, applying a different style or clearing formats may help, but first check whether doing so would remove useful borders, colors, or number formats.
Table styles and cell styles are not the same as conditional formatting. A table style provides a consistent base appearance for table parts; direct formatting can be applied to individual cells, while a conditional rule changes appearance when its condition is met. When the source of a color is unclear, inspect all three rather than repeatedly applying the same fill color.
Review custom number formats and regional settings
A custom number format can make a value look unusual even when the cell contains the right number. For example, a format may hide zeros, show a dash instead of zero, add text around a number, or display negative values in parentheses. In Format Cells, choose Custom to inspect the format code. If you do not recognize it, choose a standard category such as Number or General as a test. Keep in mind that General may not preserve a preferred display such as leading zeros in an account code.
Regional settings affect how Excel reads and displays decimal separators, thousands separators, dates, and currency symbols. A value imported with a comma decimal separator may be treated as text if Excel expects a period, or the reverse. A date entered as 7/8/2026 can mean July 8 or August 7 under different regional conventions. If formatting behaves inconsistently after importing data, check both the source format and the computer’s regional settings before changing every cell manually.
Use a short diagnostic sequence
When the reason is not obvious, test one cell at a time rather than reformatting the entire worksheet. This preserves the workbook’s structure and makes it easier to identify what is controlling the appearance.
- Select the cell and confirm the address in the Name Box, then inspect its number format with Home controls or Format Cells.
- Check Home > Conditional Formatting > Manage Rules for rules that apply to the selection.
- Check whether the value is numeric, text, a date serial, or a formula result; inspect the formula bar and any warning icon.
- Look for sheet protection, table styles, cell styles, custom formats, and insufficient column width.
- Try a standard format on a single test cell. If it works, compare that cell’s rules and styles with the original before applying a workbook-wide change.
For a clean reset, select the cell and choose Home > Editing > Clear > Clear Formats. This removes formatting, not the cell’s value or formula, but it also removes intentional number formats, fills, borders, and font choices. It does not necessarily remove conditional-formatting rules, so those may still control the appearance afterward. Use the reset on a test cell first if the workbook has carefully designed layouts.
Frequently Asked Questions
Why does Excel keep changing my cell format?
Excel may apply a format automatically as you enter familiar values, and conditional formatting or a table style may also affect what you see. Inspect the cell’s number format and any rules before assuming Excel has changed the stored value.
Why does changing a cell to Number not work?
The value may be stored as text. Convert it to a number first, using Excel’s warning prompt or a careful import-conversion method such as Text to Columns. Number format changes how a numeric value appears; it does not reliably convert text into a number.
Why does my date still look like a number?
The cell may be formatted as General or Number rather than Date. Select a date format in the Home tab or Format Cells. If it remains unchanged, check whether the entry is text or whether the date was imported in a format Excel does not recognize.
Why does Excel show hash marks instead of my value?
The column is often too narrow to display a number or date. Widen it or use AutoFit. A negative date or time can also display as hash marks, so check the underlying value if widening the column does not help.
Can I change formatting on a protected worksheet?
Only if the sheet’s protection settings allow formatting. Ask the workbook owner to unprotect the sheet or change its permissions. If a password is required, you need authorization and the correct password.
Does Clear Formats remove conditional formatting?
It removes ordinary cell formatting, such as font, fill, borders, and number format, but conditional-formatting rules may remain. Use Manage Rules to review or remove rules that continue to change the cell’s appearance.
Related
- table() in RStudio: How It Counts and Displays Data
- Data Validation and Reconciliation in Excel Explained
- PowerPoint Table Diagonal Split Cell: Practical Methods
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Error 0x80004005: Causes, Checks, and Common FixesExcel error 0x80004005 is a generic Windows failure code, not a diagnosis of one specific Excel problem. The…
- Excel Zero Error: Why #DIV/0! Appears and How to Fix ItIn Excel, a “zero error” usually means the #DIV/0! error: a formula is dividing a number by zero…
- Excel MATCH Not Working With Numbers? Causes and FixesExcel MATCH usually fails to find a number because the lookup value and the values in the search…
- Excel Error Types: What Each One MeansExcel error types are messages that explain why a formula cannot return its intended result. Common examples include…
- Excel Not Removing Duplicates? Fix Common CausesIf Excel is not removing duplicates, first check that you selected the full data range and the correct…
- Excel Filter Not Working? Common Causes and FixesWhen an Excel filter is not working, the cause is usually an incomplete data range, a blank or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.