If an Excel date appears as hashtags (such as #######), the cell usually is not wide enough to display the date in its current format. Widen the column, or choose a shorter date format; if the hashes remain, check whether a formula is producing a negative date or time.
Why Excel displays hashtags instead of a date
Excel stores most dates as numbers and uses a cell’s number format to show those numbers as calendar dates. The underlying value might be a serial number, while the cell displays something readable such as 11/2/2026 or November 2, 2026. If the formatted result does not fit in the available column width, Excel may show a row of hash marks instead.
The hashes are a display warning, not a replacement for the cell’s value. In most cases, the date remains in the worksheet and can still be used in calculations, sorting, and filtering. Select the cell and look at the formula bar to inspect its contents. If the formula bar shows a date or a numeric value, the information is likely still there; focus first on the column width and number format.
A row of hashes is different from an error such as #VALUE! or #REF!. Those error messages indicate a problem with a formula or reference. Hash marks usually mean Excel cannot show a numeric result using the current display space or date/time format.
Widen the column first
The quickest fix is to give the date column more room. In Excel for Microsoft 365 on Windows, drag the right edge of the column heading to the right. For an automatic width, double-click the boundary between that column’s heading and the next one. You can also select the column and choose Home > Format > AutoFit Column Width.
AutoFit sizes the column to fit the widest displayed entry among the cells it considers. That can be useful when a column contains dates of different lengths, but it may make the column wider than you want if another cell contains a long value. Dragging the boundary manually gives you more control. If the column is already wide, try making it wider temporarily as a quick diagnostic.
AutoFit does not always work as expected with merged cells. A merged cell spans multiple columns, so Excel cannot size one column based on that cell in the usual way. Adjust the relevant column widths manually, or avoid merging cells in data tables where reliable sizing and sorting matter.
In Excel for Mac, you can drag or double-click the boundary between column headings as well. Ribbon labels and placement can vary slightly by release, but the column-width controls are on the Home tab under Format. In Excel for the web, use the column-heading boundary or the available Format controls; if a menu option differs, resizing the boundary is the direct alternative.
Use a shorter date format
A date can fit in a column in one format and overflow in another. For example, November 2, 2026 takes more space than 11/2/2026. If the longer style is not important, select the affected cells and use the date-format dropdown on Home to choose Short Date. Long Date shows the month name and is more readable in some reports, but it requires more width.
To choose a more specific style in Windows desktop Excel, select the cells, open the Format Cells dialog from Home’s Number group, choose the Date category, and select a format. You can also right-click the selection and choose Format Cells. The dialog’s Custom category lets you use a format such as d-mmm-yy, which could display the example as 2-Nov-26. Custom formats change how a value appears; they do not alter the stored date.
When changing a format, check the whole column rather than only one cell if the data should be consistent. A worksheet may contain a mix of short dates, long dates, and custom formats, making some rows appear to have a different problem. Selecting the cells and applying one suitable date format can make the column easier to scan and may resolve the overflow without changing its width.
Check whether the value is really a date
Dates imported from a website, text file, or another system may be stored as text rather than as Excel date values. A date format alone will not convert text into a usable date. Text values often remain visible rather than turning into hashes, but it is worth checking when formatting changes seem to have no effect or date calculations do not work.
Select a cell and temporarily choose General from the Number Format dropdown. A real date commonly appears as a number, because Excel is displaying its underlying serial value. A text date generally remains text. This is a diagnostic, not a conversion step: after checking, restore the intended date format. Be aware that a cell containing a formula may display the formula’s result, and a date stored as text can be ambiguous when day and month order differs by region.
If an entire imported column needs conversion, select it and use Data > Text to Columns, then follow the wizard and specify the appropriate date order when prompted. For example, a source value written as 03/04/2026 could mean March 4 or April 3 depending on its regional convention. Confirm the source’s date order before converting; guessing can silently produce the wrong dates. Keep a copy of the original data until you have checked the converted results.
Look for negative date or time results
Column width is the common explanation, but a negative date or time result can also display as hashes under Excel’s standard 1900 date system. This often happens when a formula subtracts a later date from an earlier one, or when start and end times are in the wrong order. Widening the column will not fix a negative result that the selected date/time format cannot display.
For example, suppose A2 contains a start date of June 15, 2026, and B2 contains an end date of June 10, 2026. With the calculation placed in C2, the formula is =B2-A2. It returns -5, meaning the end date is five days before the start date. If C2 is formatted as a date in the 1900 date system, Excel may show hashes rather than a meaningful calendar date.
Check the source dates and the order of the subtraction. If the result is supposed to be a duration, use a number format suited to a duration or inspect the sign of the result; if it is supposed to be a calendar date, confirm that the formula and inputs are correct. Do not change the workbook’s date system just to hide hashes. Switching date systems can affect how existing serial values are interpreted and can cause dates to differ when workbooks are shared.
Time calculations have a related issue. A formula that calculates an end time minus a start time can be negative when the times cross midnight unless the formula accounts for the date change. Check whether the cells include dates as well as times, and verify the intended meaning of the calculation before changing its format.
Fixes that may not solve the problem
Changing the font, making the text smaller, or pressing Wrap Text is usually less reliable than widening the column or selecting a shorter date format. A date is a formatted numeric value, and Excel still needs enough horizontal room to display it. If the workbook is shared or printed, an extremely small font can also make the date difficult to read.
Changing a cell to Text is not a general fix. It can stop Excel from treating a value as a date, which may interfere with sorting and date arithmetic. Likewise, replacing the hashes by typing a date over them could overwrite a valid value or formula. Inspect the formula bar before editing, especially in a workbook maintained by other people.
If the hashes appear only in a printed page or print preview, inspect the page layout and scaling as well as the worksheet. The on-screen cell may be fine while the printed version is compressed. Use File > Print to review the preview, and consider adjusting page orientation, margins, or scaling rather than changing the underlying date values.
A practical troubleshooting order
Use this sequence to identify the cause without changing data unnecessarily:
- Select a cell showing hashes and inspect the formula bar. Note whether it contains a date, a number, or a formula.
- Temporarily widen the column. If the date appears, the problem was display width.
- If it still shows hashes, choose a shorter date format from Home’s Number Format dropdown.
- If the hashes remain, inspect the formula and source cells for a negative date or time result, or another unexpectedly large numeric value.
- If the value came from an import, check whether it is a real date or text and confirm the source’s day/month order before converting it.
- Restore the intended display format and check nearby rows, formulas, and print preview to make sure the fix suits the whole report.
This order starts with reversible display changes. It helps distinguish a narrow column from a calculation or data issue before you edit source values.
Frequently Asked Questions
Do hashtags mean my Excel date has been deleted?
No. In the usual case, the date is still stored in the cell and Excel cannot display it at the current width. Select the cell and inspect the formula bar before making changes.
Why do hashtags remain after I widen the column?
The result may be a negative date or time that the current date system and format cannot display, or the cell may have a different numeric result than expected. Check the formula and its inputs, then try a suitable format.
Will changing the cell to General fix the date?
It can help you inspect the underlying value, but it is not always the final fix. General may show a serial number instead of a readable date. Once you have checked the value, apply an appropriate date format.
Why does only one date in the column show hashes?
That cell may use a longer date format, contain a different value, or have a formula result that differs from the other rows. Compare its number format and formula with a nearby cell that displays correctly.
Can I fix hashtags in Excel for the web or on a Mac?
Yes. Widen the column by dragging the boundary between its heading and the next one, or use the available Format controls. The ribbon layout may differ from Windows desktop Excel, but adjusting width and choosing a shorter date format are the same basic remedies.
Keep dates readable and reliable
For most worksheets, a consistent date format and enough column width prevent hashes while keeping values useful for sorting and calculations. Use a short format when space is limited, a longer format when clarity matters more, and check formulas whenever widening the column does not reveal the date. Treat the hashes as a clue about display or calculation—not as a reason to overwrite the cell before you know what it contains.
Related
- Data Validation Studio: Excel Rules, Setup, and Limits
- Power Query Circular Reference: Causes and Fixes
- Excel Data Validation Source: Lists, Ranges, and Rules
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Run a Query in Google SheetsTo run a query in Google Sheets, enter the QUERY function in an empty cell, give it a…
- Where Is the Remove Formatting Button in Microsoft Word?In Microsoft Word for Microsoft 365 on Windows, find the remove-formatting button on the Home tab, in the…
- Excel Array Length: Count Elements, Rows, and ColumnsTo find the number of elements in a rectangular Excel array, multiply its row count by its column…
- Compare Two Sheets for Matches in Excel: A Practical GuideTo compare two Excel sheets for matching records, use a shared key such as an ID or email…
- Monthly Budget vs Actual Excel Template: Free SetupYes—you can make a free monthly budget-versus-actual template in Excel with columns for category, budget, actual spending, variance,…
- Excel Conditional Formatting: Color Rows by Cell TextYes. In Excel for Microsoft 365, select the rows you want to format, create a formula-based conditional formatting…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.