Excel Cell Shows All Pound Signs? Fix It Fast

Errors & fixes · Updated November 22, 2026

When an Excel cell displays a row of pound signs (####), it means the column is too narrow to show the cell’s full content, or the cell contains a negative date or time value. The fix is usually as simple as widening the column, but there are other causes worth checking.

What the Pound Signs Actually Mean

Excel uses #### as a placeholder when it cannot render the value in the current column width. This is not an error in your data—the value is still there and still used in calculations. The display issue happens because the column width is smaller than the formatted number, date, or text requires.

For numbers and dates, Excel needs enough space to show the digits, separators, and any custom formatting. For text, the cell will usually overflow into the adjacent empty cell, but if that neighbor has content, the text gets clipped and shows #### instead. The pound sign display is purely cosmetic; your data is intact.

Quick Fixes to Try First

  1. Auto-fit the column: Select the column (or columns), then double-click the right edge of the column header. Excel will resize it to fit the longest visible value.
  2. Manually widen: Drag the right edge of the column header to the desired width.
  3. Use the ribbon: Go to Home > Format > AutoFit Column Width (or Column Width to set an exact number).
  4. Check the row height: If the cell has wrap text enabled, a too-short row can also clip content, though that usually shows text truncation, not pound signs.

On a Mac, the same steps work: double-click the column header edge or use the Format menu under the Home tab. In Excel for the web, double-clicking the column edge also auto-fits, but you may need to use the Format > Column Width option from the ribbon.

Why Dates and Times Show ####

Dates and times are stored as numbers in Excel. When you enter a date like 12/31/2025, Excel displays it using the cell’s number format. If the column is too narrow, the date becomes #### because the formatted text (including slashes) is wider than the column. The same happens with times like 11:59 PM.

A special case: negative dates or times. Excel cannot display a negative date (e.g., a date before January 1, 1900) or a negative time value (like -0:30) as a standard date/time. Instead, it shows #### regardless of column width. To fix that, you must change the cell format to Number or General, or adjust the formula so it doesn’t produce a negative result.

How to Choose the Right Column Width

Auto-fit is the fastest, but sometimes you want a consistent width across many columns. For that, select multiple columns, then set a specific width (e.g., 15 characters) via Home > Format > Column Width. Remember that the width is measured in characters of the default font (Calibri 11).

If you have a long number with custom formatting (like currency with thousands separators), auto-fit may still not be enough if the number is very large. In that case, consider reducing decimal places or using a shorter date format (e.g., m/d/yy instead of mmmm d, yyyy).

Common Misconception: Is My Data Lost?

No, the data is not lost. The #### display is only a rendering issue. If you click the cell, the full value appears in the formula bar. You can also copy the cell and paste it elsewhere—it will paste the actual value, not the pound signs. This is a frequent worry for new users, but rest assured, your numbers and dates are safe.

Another misconception is that #### means an error like #VALUE! or #DIV/0!. Those are true errors and start with a hash but are followed by a word. #### is unique in that it only indicates a width or negative date/time issue.

When It’s Not About Width: Negative Times

If you widen the column and still see ####, check if the value is a negative time. For example, if you subtract a later time from an earlier time (e.g., =B2-A2 where B2 is 8:00 AM and A2 is 5:00 PM), you get a negative decimal. Excel cannot display that as a time, so it shows ####. To fix, use the MOD function to get a positive difference, or change the cell format to Number to see the decimal value.

For example, with start time in A2 and end time in B2, use =MOD(B2-A2,1) to get the positive elapsed time. This works because Excel times are fractions of a day (0 to 1).

Frequently Asked Questions

Why does Excel show #### instead of my number?

The most common reason is the column is too narrow. Double-click the column header’s right edge to auto-fit. If that doesn’t work, the number may have a custom format that requires more space, or the cell contains a negative date/time.

How do I stop #### from appearing when I print?

Before printing, go to Page Layout > Scale to Fit and set the width to 1 page, or manually adjust column widths. Also check Print Preview to ensure all columns fit. Often, auto-fitting before printing solves it.

Can I hide the #### without changing the column width?

You can change the cell’s number format to General or Text, but that may alter how the value displays. For dates, you could use a shorter date format. For text, you could enable Wrap Text and increase row height, but that changes the layout. Widening the column is usually the cleanest fix.

Does #### affect formulas that reference that cell?

No. Formulas use the underlying value, not the displayed text. Even if the cell shows ####, any formula that references it will calculate normally. The display is purely cosmetic.

Why does a negative time show #### even after widening?

Excel cannot display negative times as time values. You must either change the format to Number (to see the decimal) or adjust your formula to avoid a negative result, such as using =MOD(end-start,1).

Final Tips for Avoiding #### in the Future

  • Set a reasonable default column width for your data (e.g., 12-15 characters) before entering data.
  • Use shorter date formats like m/d/yy if you don’t need the full year.
  • For large numbers, consider using scientific notation or reducing decimal places.
  • If you frequently copy data from other sources, use Paste Special > Values to avoid bringing in weird formats.

In short, #### is Excel’s way of saying “I can’t fit this in the space you gave me.” A quick column resize fixes 95% of cases. For the rest, check for negative dates/times. Your data is always safe, and now you know exactly what to do.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.