Excel Cells Showing Number Signs? Causes and Fixes

How-to basics · Updated November 19, 2026

An Excel cell showing number signs (####) usually means its column is too narrow to display a numeric value, date, or time; widen the column first. If the hashes remain, check for a negative date or time, since some values cannot be displayed in Excel’s date system even when there is plenty of room.

Why Excel displays number signs

Excel stores numbers, dates, and times as values, then uses the cell’s number format to decide how to show them. A date, for example, is stored as a serial number and displayed as a calendar date. If the formatted result will not fit in the cell, Excel may show a row of number signs instead of the value. This is a display warning, not a replacement of the underlying data.

The most common case is a narrow column. A long number such as 123456789 may need more room than a short value such as 42. Dates and times can also take more space than their underlying serial values: 11/03/2026 is wider than 45200, and a format that includes both date and time needs still more room. A cell can therefore show #### after someone changes its number format, increases the number of decimal places, or enters a longer value.

Column width is not the only possible cause. In the standard 1900 date system, Excel cannot display negative date or time serials as ordinary dates or times, so a formula that produces one may appear as ####. Less commonly, a cell may be formatted in a way that makes its result hard to interpret, or the visible hashes may actually be text rather than Excel’s overflow indicator.

Fix it by widening or autofitting the column

Start with the simplest repair: give the cell more horizontal space. To adjust just one column, point to the right boundary of its lettered heading and drag it to the right. To fit the widest displayed entry automatically, double-click that boundary. If multiple columns are selected, AutoFit adjusts each selected column to its contents.

You can also use the ribbon in Excel for Microsoft 365 on Windows:

  1. Select the affected column or columns by clicking their lettered headings. To select the whole worksheet, click the triangle at the top-left corner between the row numbers and column letters.
  2. Choose Home > Format > AutoFit Column Width.
  3. If the result is still cramped, drag the column boundary wider or choose Home > Format > Column Width and enter a larger width.

AutoFit uses the contents and formatting of cells to choose a width; it does not change the value. If a very long entry makes the column too wide for the sheet, set a practical width manually and choose a shorter display format instead. The same boundary-drag and AutoFit ideas are available in Excel for Mac and Excel for the web, although ribbon placement and window layout can differ slightly by version.

Use a shorter number format when a wide column is impractical

Sometimes the column is intentionally narrow, such as in a dashboard or printed report. In that case, change how the value is displayed rather than expanding the column. Select the cell and use Home > Number to choose a suitable category, or open the Format Cells dialog from the Number group’s dialog launcher for more options.

  • Large whole numbers: If the exact digits are not needed in the display, a format using thousands separators or fewer decimal places may be more readable. Be careful: reducing displayed decimal places does not necessarily round or change the stored value.
  • Dates: Choose a shorter date format, such as a format showing a two-digit year, if that is appropriate for the workbook. Do not shorten a date if doing so would make the year ambiguous for your readers.
  • Times: A format showing hours and minutes takes less room than one that includes seconds or a date.
  • Very large or small values: Scientific notation can make some values compact, but it is not suitable when readers need to see every digit.

To inspect available formats, press Ctrl+1 on Windows to open Format Cells. On Mac, use Command+1. In Excel for the web, select the cell and use the number-format controls on the Home tab; some detailed formatting options may be more limited than in the desktop app. Changing a format usually changes only the appearance, not the value used in calculations.

Check dates and times that are negative

If widening the column does nothing, consider whether the value is a negative date or time. Excel’s standard 1900 date system represents dates as serial numbers beginning in 1900. A formula that subtracts a later date from an earlier date can return a negative number; when formatted as a date, that result may display as ####. A time calculation can do the same thing when the end time is earlier than the start time and the calculation does not account for crossing midnight.

For example, subtracting a clock-in time of 10:00 PM from a clock-out time of 6:00 AM without handling the overnight shift produces a negative duration. The hashes are a clue to check the calculation, not evidence that the column needs more width. Review the input dates and the order of subtraction, and decide whether the result should be a positive elapsed duration, a negative difference, or an error that needs correcting.

Excel for Windows also supports a 1904 date system in some workbooks. Switching date systems can affect how existing date serials are interpreted, so it is not a quick cosmetic fix and can shift displayed dates substantially. Do not change the workbook’s date system just to remove hashes unless you understand how the change affects all dates in that file. For a duration that can be negative, consider whether the workbook should show a signed number of hours rather than a date/time format, or adjust the calculation and presentation to suit the task.

Tell a width problem from literal hash characters

Not every row of #### comes from Excel failing to fit a value. A cell may contain the characters #### as text, perhaps because they were pasted in from another source. A formula may also return hash characters as text. In those cases, widening the column will not reveal a hidden number.

Click the cell and look at the formula bar. If it shows a number, date, time, or a formula rather than a string of hash characters, the visible marks are likely a formatting or display issue. If the formula bar itself shows ####, the characters may be the cell’s actual content or the result returned by a formula. You can also select the cell and temporarily choose Home > Number > General. If the underlying value becomes visible, the original number format was involved; if the literal hashes remain, investigate the source text or formula.

Another useful clue is whether neighboring cells show the same pattern. If only one narrow column contains hashes and its entries are longer or formatted differently, width is likely. If hashes appear only for a particular calculated row, check that row’s inputs and result, especially for negative date or time arithmetic.

What number signs do not mean

Seeing #### does not, by itself, mean that the workbook is damaged, that a formula has failed, or that Excel has deleted the value. In the common narrow-column case, the value remains in the cell and can still be used in formulas, sorting, and calculations. Widening the column changes what is visible, not the stored data.

It is also different from text overflowing into an empty neighboring cell. Ordinary text that is too long may visually continue into adjacent blank cells; if the neighboring cell contains something, the text is clipped at the cell boundary. That behavior is not the same as the row of number signs Excel uses for many narrow numeric, date, and time displays. Do not assume that turning on text wrapping is the right fix for ####; wrapping is mainly for displaying long text on multiple lines and may not resolve an invalid negative date or time.

A quick diagnostic checklist

Use these checks in order so you do not change the workbook unnecessarily:

  1. AutoFit the column or widen it manually. If the value appears, the cause was insufficient width.
  2. Look at the formula bar to see whether the cell contains a value, a formula, or literal hash characters.
  3. Check the number format. Temporarily select General or a shorter appropriate format to see whether the displayed result changes.
  4. If the cell contains a formula, inspect its inputs and arithmetic. For dates or times, look for a negative result or an overnight interval that has not been handled.
  5. Compare the same value in another cell or a new workbook copy if needed. This can help distinguish a cell-specific format from a calculation issue, but avoid pasting over the original data while diagnosing.

Keep the display readable in shared workbooks

When preparing a sheet for other people, make the display choice deliberate. Autofitting every column can create an extremely wide worksheet if one cell contains a long note or identifier. A more usable approach is to set sensible widths, use appropriate date and number formats, and keep full values available for calculations. For a report, you might show a concise date while retaining the real date value in the cell.

Be especially careful with identifiers such as account numbers, postal codes, and product codes. These may look numeric but are often labels, not quantities. Changing them to a numeric format can remove leading zeros, and scientific notation can obscure digits. Store and format identifiers as text when their exact characters matter. That is a separate issue from ####, but it often comes up when people widen a column and then discover that a long identifier has been altered or displayed unexpectedly.

Frequently Asked Questions

Does #### mean my Excel formula is wrong?
No. It often means the result exists but will not fit in the column. If widening the column does not help, check whether the formula returns a negative date or time, or whether the hashes are actually text.

Why do dates show #### even when the column looks wide?
A negative date serial in Excel’s 1900 date system can display as #### regardless of width. Check the formula and date inputs, and confirm that the cell is using a suitable date format.

Will widening a column change my number?
No. Dragging a column boundary or using AutoFit changes the display space, not the stored value. Changing a number format also normally changes presentation rather than the value used in calculations.

Why does AutoFit not fix the hashes?
The cause may not be column width. Check for a negative date or time, literal hash characters, or a formula that returns hashes as text. Also confirm that you autofitted the column containing the affected cell.

Can I replace #### with zeros?
Do not replace the marks with zeros unless zero is genuinely the correct value. In most cases the underlying value is already present; widen the column or correct the date/time calculation instead.

Related

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.