When an Excel cell shows hashtags (###), it means the column is too narrow to display the cell’s content. The fix is to widen the column, adjust the row height, or change the number format. If the cell contains a date or number, the ### symbol specifically indicates that the value is too long for the current column width.
Why Excel Shows ### Instead of Your Data
Excel uses the ### display as a placeholder when the content of a cell cannot be fully shown within the current column width. This is not an error in your data—the value is still stored correctly in the cell. The most common cause is a column that is too narrow for the text, number, or date you’ve entered. For example, if you type “123456789” into a cell that is only wide enough for five characters, Excel will display #####. Similarly, dates like “12/31/2025” will show as ##### if the column is not wide enough to fit the full date format.
Another reason for ### is when a cell contains a negative date or time value. Excel does not support negative dates or times, and it will display ##### regardless of column width. For instance, if you subtract a later date from an earlier one and the result is negative, the cell will show #####. To fix this, you need to adjust your formula to produce a positive value or use a different format.
How to Fix ### in Excel (Step-by-Step)
Follow these steps to resolve the hashtag display in your Excel worksheet:
- Widen the column: Hover your mouse over the right edge of the column header (e.g., the line between columns A and B). When the cursor changes to a double-headed arrow, double-click to auto-fit the column to the longest content. Alternatively, drag the edge to the desired width.
- Use the Ribbon: Select the cell or column, go to Home > Format (in the Cells group), and choose Column Width to enter a specific number, or select AutoFit Column Width.
- Adjust row height: If the cell has wrap text enabled and the row is too short, the text may be cut off, but this usually shows as clipped text, not ###. However, for numbers, ### appears only when the column is too narrow.
- Change the number format: If widening doesn’t help (e.g., for a negative date), select the cell, go to Home > Number Format dropdown, and choose General or a different format like Number to see the raw value.
If you have many columns with ###, you can select the entire worksheet (Ctrl+A) and double-click any column boundary to auto-fit all columns at once.
Common Situations That Trigger ###
Here are the typical scenarios where you’ll see hashtags in Excel:
- Long numbers: Entering a number with more digits than the column width (e.g., a 15-digit credit card number).
- Dates: A date like “November 15, 2025” in a narrow column.
- Time values: Times with seconds or milliseconds that exceed the column width.
- Negative dates/times: Results from formulas that produce negative date or time serial numbers.
- Custom formats: Applying a custom number format with many characters (e.g., “000-000-0000”) that doesn’t fit.
In most cases, widening the column solves the issue instantly. If you see ### after merging cells, the merged area might be too small; unmerge and adjust the column widths instead.
Is ### a Sign of a Data Error?
No, ### is not an error in the traditional sense. Unlike #DIV/0! or #VALUE!, which indicate formula problems, ### simply means the display is too small. Your data is intact and will appear correctly once the column is widened or the format is changed. This is a common misconception—users often think their data is corrupted, but it’s purely a visual limitation.
However, if you see ### and widening the column doesn’t help, check if the cell contains a negative date or time. For example, if you have a formula like =A1-B1 where A1 is earlier than B1, the result is a negative serial number, which Excel cannot display as a date. In that case, you’ll need to change the formula to use =ABS(A1-B1) or format the cell as General to see the negative number.
How to Prevent ### from Appearing
To avoid the hashtag display in the future, consider these tips:
- Set a wider default column width: Go to Home > Format > Default Width and increase the value (e.g., from 8.43 to 12).
- Use text format for long identifiers: If you’re entering things like product codes or phone numbers, format the cells as Text before typing to prevent scientific notation and ### issues.
- Reduce the number of decimal places: For large numbers, applying a format like Number with 0 decimal places can make them fit better.
- Use shorter date formats: Choose a date format like mm/dd/yyyy instead of dddd, mmmm dd, yyyy to save space.
If you frequently work with large numbers, consider using the General format and letting Excel display numbers in scientific notation for very large values, but note that this can also cause ### if the column is too narrow.
Excel vs. Google Sheets: Hashtag Behavior
In Google Sheets, a similar issue occurs, but the display is slightly different. When a column is too narrow, Google Sheets shows the number truncated with a small gray triangle in the corner of the cell, not ###. However, if you have a negative date or time, Google Sheets will show ##### as well. To fix it in Google Sheets, you can drag the column boundary or use Format > Column > Resize column to auto-fit. In Excel for Mac, the behavior is identical to Windows; the fix is the same. In Excel for the web, you can also widen columns by dragging, but the auto-fit double-click works the same way.
Frequently Asked Questions
Why does my Excel cell show ##### even after widening the column?
If widening doesn’t fix it, the cell likely contains a negative date or time value. Excel cannot display negative dates or times, so it shows ##### regardless of column width. To fix this, change the formula to produce a positive result, or format the cell as General to see the raw negative number.
Can ### be a sign of a formula error?
No, ### is not a formula error. It only indicates a display issue. If your formula has a real error, you’ll see something like #VALUE! or #REF!. ### means the content is too wide for the column.
How do I make all columns auto-fit at once?
Select the entire worksheet by clicking the triangle at the top-left corner (or press Ctrl+A), then double-click any column boundary. This will auto-fit all columns to their content. On a Mac, use Command+A.
What if I see ### in a cell with text?
Text normally overflows into adjacent cells if they are empty, so ### for text is rare. If you see ### in a text cell, it’s likely because the cell has wrap text enabled and the row height is too small. Increase the row height or disable wrap text to see the full text.
Does ### affect printing?
Yes, if you print a worksheet with ###, the cells will print as ### because the column width is too narrow. Widen the columns before printing to ensure your data appears correctly.
How can I see the full value in a cell without widening the column?
You can click on the cell and look at the Formula Bar, which always shows the full content. Alternatively, you can temporarily change the font size to a smaller value, but widening the column is the best permanent solution.
Related
- Excel Biweekly Timesheet Template with Lunch
- X++ String Split: How to Use str2con and Other Methods
- Excel Before Close Event: How to Run Code on Save
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Multiply Formula Not Working? Fix Common CausesIf an Excel multiplication formula is not working, first check that it uses the asterisk (*) between valid…
- Excel Filter Button Not Working? Fix Common CausesIf the Excel filter button is missing, greyed out, or not filtering the rows you expect, check that…
- Excel Won’t Let You Merge Cells? Fix the Common CausesIf Excel won’t let you merge cells, first exit cell-editing mode by pressing Esc, then select one continuous…
- Excel Error Symbols: What They Mean and How to Fix ThemExcel’s error symbols are values such as #VALUE! and #DIV/0! that explain why a formula cannot return a…
- Excel Cell Format Not Changing? Find and Fix the CauseIf an Excel cell format is not changing, first check whether conditional formatting is overriding what you set;…
- Excel Text to Columns With Dates: Fix Date FormatsTo convert text dates in Excel, select the cells, choose Data > Text to Columns, move through the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.