If an Excel date turns into hashtags such as #####, the cell usually cannot display the formatted value at its current column width; the date itself is often still intact. Widen or autofit the column first, then check the cell’s number format and value if the hashes remain.
Why Excel displays hashtags instead of a date
Excel stores dates as numbers and uses a number format to display those numbers as calendar dates. For example, a cell may contain a date value but show it as a short date such as 11/2/2026. If the column is too narrow for the formatted date, Excel may show a row of hash characters instead. The characters are a display warning, not a replacement value or proof that the date has been deleted.
This is why the same date can appear normally in one column and as hashes in another: the columns may have different widths, or the cells may use different date formats. A long format such as Monday, November 2, 2026 needs more room than a short format such as 11/2/26. The width required can also depend on the font and the particular date.
Hashtags can also appear when Excel cannot display a negative date or time using the workbook’s date system. That is a different issue from a narrow column. Widening the column will not make an unsupported negative date display as a normal calendar date, so it is useful to check the value and format if resizing does not help.
Widen or autofit the column
For Microsoft Excel for Microsoft 365 on Windows, try the quickest fix first:
- Point to the right edge of the column letter at the top of the worksheet. For example, to adjust column B, point between the B and C headers.
- When the pointer changes to a column-resize symbol, double-click the boundary. Excel adjusts the column to fit its contents.
- If you prefer a set width, drag the boundary to the right until the date appears.
You can also select the column and choose Home > Format > AutoFit Column Width. To autofit several columns together, select their column headers first, then use the same command. Autofit considers the contents of the selected columns, so one unusually long entry elsewhere in a column can make the whole column much wider than a date needs.
On a Mac, double-clicking or dragging a column-header boundary works similarly. The Home tab also provides a Format menu with an AutoFit Column Width command in current desktop versions. In Excel for the web, you can resize by dragging or double-clicking a column boundary; the available ribbon options can vary with the web interface. If the sheet uses a fixed layout, consider shortening the date format rather than making the column wider.
Use a shorter date format when width is limited
If a report or template requires narrow columns, changing the display format may be more appropriate than resizing. Select the affected cells, open the Format Cells dialog with Ctrl+1 on Windows, choose the Date category, and select a shorter date type. You can also use the number-format drop-down in the Home tab’s Number group and choose a date format available there.
A short date such as 11/2/2026 usually takes less space than a long date such as Monday, November 2, 2026. The exact appearance depends on the format and regional settings. To set a particular pattern, use the Format Cells dialog’s Custom category and enter a format such as yyyy-mm-dd. That displays a year-month-day style date, for example 2026-11-02, when the cell contains a valid Excel date value.
On Mac, Command+1 opens Format Cells in current desktop Excel. In Excel for the web, use the number-format controls on the Home tab; some detailed custom-format options may be easier to set in the desktop app. Changing a format changes how a value is displayed, not the underlying date. Choosing General may reveal a serial number instead of a calendar date, so it is useful for diagnosis but usually not a reader-friendly final format.
Check whether the cell contains a real date
Sometimes a date-looking entry is stored as text, especially after copying data from a website, importing a CSV file, or receiving dates written in a different regional order. Text that looks like a date is not always treated by Excel as a date value, and changing the column width will not convert it. Select the cell and inspect the formula bar; you can also temporarily apply the General or Number format to a suspected date to see whether Excel displays a serial number.
If the value is text, first confirm how the source represents dates. For example, 03/04/2026 could mean March 4 or April 3 depending on the source’s regional convention. Avoid converting a whole column until that meaning is clear. If the data came from a CSV, importing it through Excel’s data import tools lets you check the column type and, where available, choose a locale that matches the source. For a small number of entries, re-entering a date in a format Excel recognizes under your regional settings may be simplest.
Also check whether a formula is producing an unexpected result. Select the cell and read the formula bar. A formula might return a negative number, an error, or a value with a time component rather than the positive calendar date you expected. Fixing the formula or its input is different from changing the column width; formatting cannot turn an invalid result into the intended date.
When negative dates or times are the cause
Excel’s usual 1900 date system represents dates as serial values, with whole-number steps for days and fractional parts for times. In that system, a calculation that produces a negative date or time may display as hashes instead of a conventional date or clock time. This can happen in a duration calculation when the end time is earlier than the start time, or in a date subtraction when the order of the dates is reversed.
Check the arithmetic and the intended meaning before changing anything. If the result is meant to be an elapsed time, confirm that the start and end values are in the right order and that an overnight period is handled correctly. If it is meant to be a calendar date, a negative result may indicate a reversed subtraction or an unexpected input. Simply applying a different date format will not correct the calculation.
Excel workbooks can use either the 1900 or 1904 date system, and the systems assign different serial values to the same calendar date. The workbook setting is under File > Options > Advanced on Windows, in the section for calculating the workbook; the exact placement may vary slightly by version. Do not switch the date system just to remove hashes. Changing it can affect how existing date serials are interpreted, so verify the workbook’s purpose and data before altering this setting.
Common situations and what to check
- A date column suddenly shows hashes after editing: The column may have been narrowed, or a longer date format may have been applied. Autofit the column or choose a shorter date format.
- Only some rows show hashes: Those cells may contain longer dates, times, or different formats from the rest of the column. Compare their number formats and values with a row that displays correctly.
- Hashes remain after widening: Check for a negative date or time, a formula returning an unexpected value, or a custom format that does not suit the value.
- The cell literally contains hash characters: If the formula bar shows the characters as entered text, this is not Excel’s narrow-column display. Correct the cell content or the source data instead.
- A date becomes a large number after changing the format: The value may still be a valid date stored as a serial number. Apply a Date format to display it as a calendar date again.
These checks help separate a display problem from a data problem. That distinction matters in shared workbooks: widening a column or applying a date format is usually safe for the value, while replacing, converting, or recalculating data can change what the workbook contains.
Keep dates readable when sharing a workbook
Before sending a spreadsheet, look at dates in the actual layout in which other people will use it. A column that fits on your screen may be resized or viewed at a different zoom level elsewhere, and a long date format can become inconvenient in a compact report. A clear short format, consistent across the date column, often makes a sheet easier to scan without sacrificing the underlying value.
Consider using an unambiguous format such as year-month-day when readers may work across regions. A date written as 04/05/2026 can be interpreted differently in different locales, while 2026-05-04 is less ambiguous. The cell still needs to contain a genuine date value if readers are expected to sort, filter, or calculate with it; a string that merely resembles a date may not behave the same way.
When a workbook contains formulas, test a few representative rows after changing a format or adjusting a calculation. Confirm that dates sort in chronological order and that any date-based calculations still make sense. Avoid fixing visible hashes by replacing cells with typed text unless text is genuinely what the workbook requires. A display adjustment is preferable when the underlying date is already correct.
Frequently Asked Questions
Do hashtags mean my Excel date was deleted?
No. In the common narrow-column case, Excel is still holding the cell value and showing hashes because it cannot fit the formatted result. Widen the column or use a shorter date format, then check the value if the hashes persist.
Why does autofit not fix the hashtags?
Autofit addresses column width, but it cannot resolve every cause. A negative date or time, an unexpected formula result, or a custom format may keep the hashes visible. Check the value and format after resizing.
Will changing the date format change the date itself?
Usually, changing a cell’s number format changes only its appearance. For instance, a valid date can be shown in a short or long style. Converting text to a date or changing a formula is a separate operation and can affect the underlying data.
Why did my date turn into a number?
Excel stores dates as serial numbers. If you apply General or Number formatting, Excel may show that stored number rather than a calendar-style date. Choose an appropriate Date format to display it as a date again.
Can I fix the hashes without widening the column?
Yes, if the value is a valid date and the issue is simply that its current format is too long. Choose a shorter date format, such as a compact numeric date or a year-month-day pattern. If the issue is a negative value, fix the calculation or input instead.
Related
- Excel Data Validation Date Picker: Setup and Options
- Excel Data Validation for Dates: Rules and Examples
- Data Validation Checks in Excel: Rules and Examples
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 Clear Cache in Outlook CalendarTo clear the local cache for a calendar in classic Outlook for Windows, right-click the calendar, choose Properties,…
- Excel Freeze Panes: Keep Any Rows or Columns VisibleTo freeze rows or columns other than the top row in Excel for Microsoft 365 on Windows, select…
- Delete a Page in Word: Steps for Blank or Full PagesTo delete a page in Microsoft Word, select its contents and press Delete, or remove the paragraph mark…
- Set Out of Office in Outlook on the Web: Step-by-StepTo set an out-of-office reply in Outlook on the web, open Settings, find Automatic replies, turn them on,…
- Excel Data Validation List Limit and Practical WorkaroundsIn Excel, a list typed directly into the Data Validation Source box is limited to 255 characters in…
- How to Change the View in Outlook Sent ItemsTo change how sent messages appear, open the Sent Items folder and use Outlook’s view controls: in classic…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.