If an Excel cell displays ##### instead of a value, the most common reason is that its column is too narrow to show the number, date, or time in its current format. Widen the column first; if the hashes remain, check for a negative date or time, a custom number format, or hash marks that are actually part of the cell’s contents.
What hashes in Excel usually mean
In Microsoft Excel for Microsoft 365 on Windows, a run of number signs is generally a display clue, not an error value. Excel has a value or formula result for the cell but cannot show it in the available width using the chosen number format. That is why a cell can show ##### even though the formula bar displays a normal value when you select it.
The issue most often affects numeric values and dates or times. For example, a column that is only a few characters wide may not fit a formatted value such as 125,000.00 or a date such as November 2, 2026. The same underlying value may fit immediately if the column is widened or the display format is made shorter.
There is an important distinction: if someone typed several hash characters as text, those characters are the actual cell contents. Widening the column will not remove them. Checking the formula bar is a quick way to tell whether the cell contains a value being displayed as hashes or literal hash marks.
Check the cell before changing it
Select a cell showing hashes and look at the formula bar above the worksheet. If it shows a number, date, time, text, or formula rather than a line of hash marks, Excel is displaying the result differently from what you see in the grid. The formula bar can also show a formula whose result is too wide for the cell.
Next, check the number format. On the Home tab, look in the Number group at the format drop-down. A value may be set to Date, Time, Currency, Accounting, or a custom format, even if the data itself looks like an ordinary number. The format determines how Excel presents the value; it does not necessarily change the stored value.
- If the formula bar shows the expected value and the cell is numeric or a date, try widening the column.
- If the value is a date or time and widening does not help, check whether it is negative.
- If the formula bar itself contains hash characters, the hashes are probably literal text or part of a formula result.
- If only some cells in a column show hashes, compare their formats and values with neighboring cells.
Widen the column or use AutoFit
The quickest fix is usually to give the column more space. Point to the right boundary of the column letter at the top of the worksheet, then drag the boundary to the right. You can also double-click that boundary to AutoFit the column to the widest displayed entry in it.
To use the ribbon, select the column or a cell in it and choose Home > Format > AutoFit Column Width. You can instead choose Home > Format > Column Width and enter a specific width. AutoFit is convenient, but a long entry elsewhere in the column can make the whole column much wider than you want. In that case, set a width manually or use a shorter display format.
AutoFit does not always behave as expected with merged cells. If a cell spans multiple columns, Excel may not automatically calculate a useful width for the merged area. Widening the relevant columns manually, unmerging the cells, or using a layout that does not depend on merged cells can help. If the hashes appear in a table, remember that changing a column’s width affects the entire worksheet column, not just one row.
On Excel for Mac, you can drag or double-click the boundary between column headings in much the same way. Ribbon wording and placement can vary slightly by release, but look for the Home tab’s Format options and AutoFit Column Width. Excel for the web also supports changing column width from the column boundary and its formatting controls.
Make dates, times, and numbers easier to fit
Sometimes the column width is important to the layout, so widening it is not the best choice. You can make the displayed value shorter without changing its underlying value. For dates, select the cells and choose a shorter option such as a numeric date format from the Number format list on the Home tab. For instance, a short date may take less space than a format that spells out the day and month.
For numbers, reduce unnecessary decimal places using the decrease-decimal control in the Home tab’s Number group, or choose a less elaborate number format. A value displayed as 12,345.6789 may fit as 12,346 if rounding to zero displayed decimal places is acceptable for the presentation. The stored value is not necessarily rounded just because fewer decimal places are shown, so a later calculation can still use the underlying precision.
Currency and Accounting formats often need more width because they include currency symbols, separators, decimal places, or aligned symbols. If a report does not need all of those elements, consider a more compact number format. Do not change the format solely to hide hashes if readers need to see the exact units, currency, or precision; make sure the shorter display remains clear.
You can review and adjust formatting in the Format Cells dialog. Select the cells and press Ctrl+1 on Windows, or Command+1 on Mac, then use the Number tab to choose a category and format. If you use the Alignment tab, Shrink to fit can reduce the displayed text size so it fits in the existing width. This can be useful for a small label or value, but it may make text difficult to read, especially across a large range.
When widening the column does not fix it
A negative date or time is a common exception. Excel stores dates and times as serial numbers, but its standard date system does not display negative date or time values as ordinary calendar dates or clock times. In many such cases, a cell formatted as a date or time shows ##### even after you make the column very wide.
Check the value or the formula that produces it. A subtraction such as an end date minus a later start date can produce a negative result, as can a time calculation that crosses midnight if the calculation does not account for the date change. The right remedy depends on what the result is supposed to represent: correct the inputs or calculation, show a signed duration as a number, or represent an overnight interval in a way that produces the intended result. Simply widening the column will not make a negative date display as a valid calendar date.
Also consider whether the cell uses a custom number format. Custom formats can make values appear unusual or suppress some displayed content, and a format can produce a display that does not match what you expect. To test whether formatting is involved, select the cell and temporarily choose General in the Number format list. This changes how the value is shown, not the underlying value. If the display becomes understandable, choose an appropriate format again rather than leaving it as General automatically.
If a formula returns text made of hash characters, the column-width explanation may not apply. Inspect the formula and its inputs, and compare the formula-bar result with the displayed cell. A formula can also return a text string that includes hashes intentionally, for example as a placeholder. In that case, revise the formula or source data if the placeholder is not wanted.
Literal hash marks and other look-alikes
To check whether hashes are actual text, select the cell and read the formula bar. If it shows ##### there too, the marks are likely stored as text or returned by a formula. If the cell is part of an imported file, the source may use hash marks to represent missing, unavailable, or masked information. Excel cannot infer what that source-specific placeholder means; check the file’s documentation or the system that produced it before replacing the marks.
Do not confuse a cell full of hashes with an Excel error such as #VALUE! or #DIV/0!. Those error values have named text and usually indicate a problem with a formula or reference. A plain row of ##### most often indicates a display limitation or a date/time value that Excel cannot render in that format. If you see a longer sequence, such as ########, the basic checks are still the same: inspect the formula bar, format, and column width.
It is also possible for the formula bar to show a formula while the cell shows hashes. That does not prove the formula is broken. Select the cell, check whether the formula evaluates to a number or date, and then test the column width and format. If the formula bar shows an error name instead, investigate that error separately.
Choose a fix that preserves meaning
There is no single best fix for every worksheet. Widening the column preserves the existing number format and is generally the safest first step. A shorter date or number format is useful when a fixed-width report matters. Shrink to fit can preserve the column width but may make the result hard to read. Changing a date or time to General can help diagnose the issue, but it may expose a serial number instead of a reader-friendly date.
Before altering a whole column, consider whether cells contain different kinds of data. A column might mix dates, labels, and amounts, or have one unusually long note. Selecting the entire column and changing its format could make other entries harder to understand. If the worksheet is a shared report, retain clear units and labels so that a compact display does not become ambiguous.
- Choose AutoFit when the column can grow and you want Excel to size it around its contents.
- Choose a shorter number format when you need to preserve a planned column width.
- Use Shrink to fit sparingly when fitting a small amount of text matters more than consistent font size.
- Investigate the calculation rather than the width when a date or time result is negative.
- Check the source before replacing literal hashes that may stand for missing or protected data.
Prevent hashes in future worksheets
Plan column widths around the values readers need to see, especially for dates, currency, and long identifiers. Apply number formats before entering or importing data where practical, and test the layout with realistic maximum values rather than only short examples. A column that fits a value of 999 may not fit 100,000, even if both values are valid for the same field.
When preparing a report for printing or sharing, inspect the worksheet at its intended zoom and page layout. A column that looks wide enough on screen may still be cramped in a printed page setup. Avoid using hashes as a generic way to cover data: if the goal is to mask confidential information, a display format is not a reliable security measure because the underlying value may remain accessible in the workbook. Use appropriate access controls and remove sensitive data when it should not be shared.
Frequently Asked Questions
Does ##### mean my Excel formula is wrong?
No, not by itself. The formula may be correct while its numeric, date, or time result does not fit the column. Check the formula bar and widen the column first. If the formula bar shows an actual error such as #VALUE!, troubleshoot that error separately.
Why do I still see ##### after AutoFit?
A negative date or time is a likely cause if the cell is formatted as a date or time. A custom format or merged cell can also complicate the display. Inspect the value and format, and check whether the calculation produces a negative result.
Will changing the cell to General delete or change my value?
Changing the number format generally changes how Excel displays a value, not the stored value or formula. However, General may show a date serial number or a number with a different appearance. Check the result before keeping the new format.
Why does only one cell in the column show hashes?
That cell may contain a larger number, a longer date display, or a different number format than its neighbors. It may also be the only cell with a negative date or time result. Compare its value and formatting with adjacent cells.
What if the formula bar also shows #####?
The hash marks may be literal text in the cell or text returned by a formula, rather than Excel’s narrow-column display. Inspect the source data or formula, and check whether the marks are being used as a placeholder before editing them.
Related
- Data Validation and Reconciliation in Excel Explained
- PowerPoint Table Diagonal Split Cell: Practical Methods
- Data Validation and Quality Assurance in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets: Count Weekdays Between DatesYes. In Google Sheets, use =NETWORKDAYS(A2,B2) to count Monday-through-Friday workdays between the start date in A2 and the…
- Microsoft Word Compare Documents Not Responding? FixesIf Microsoft Word’s Compare Documents command is not responding, first give it a little time, then try comparing…
- Excel Merge Cells in Each Row Without Losing ValuesTo merge cells horizontally in every row of a selected range in Excel for Microsoft 365 on Windows,…
- Excel Trendlines: How to Add, Format, and Read ThemTo add a trendline in Excel for Microsoft 365 on Windows, select a chart, choose the plus-shaped Chart…
- How to Sort A to Z in Google Sheets Without ErrorsTo sort a list A to Z in Google Sheets, select the full range of related cells, open…
- Google Sheets Auto Sum: How to Total a Column AutomaticallyTo auto sum a column in Google Sheets, select the cell where you want the total, choose the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.