# Excel Shows Hashtags Instead of Numbers? Read This

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Fixing the converted file
- Canonical: https://fastbankconvert.com/blog/excel-shows-hashtags-instead-of-numbers

> Excel shows hashtags instead of numbers when a column is too narrow, a date is negative or a value is too long. Here is the fix for each case.
Excel shows hashtags instead of numbers when the value cannot be displayed in the space or format it has. Usually the column is too narrow, and double-clicking the column edge fixes it. If widening does nothing, the cell holds a negative date or time. The number itself is intact either way; only its display is blocked.

## Why does Excel show hashtags instead of numbers?

A row of hashtags, #####, is Excel saying it cannot draw the value in that cell. It is a display message, not a calculation error, and the value underneath is unchanged. Select the cell and the formula bar shows the real number, which proves nothing was lost.

Microsoft's guide on [how to correct a ##### error](https://support.microsoft.com/en-us/excel/how-to-correct-a-error) gives two causes. Excel might show ##### when a column is not wide enough to show all of the cell contents, and formulas can show it when they return dates and times as negative values.

In a converted file, a column sized for a short value such as "-12.40" cannot fit "-12,480.75". Text overflows into the next cell when that cell is empty. Numbers and dates never overflow, so they turn into hashtags instead.

## Narrow columns: hashtag cells that AutoFit clears

A narrow column is the cause in most cases, and AutoFit is the fix. Double-click the right edge of the column header and Excel widens the column to fit its longest value. The hashtags turn back into numbers at once.

To fix every column in one step:

1. Select the whole sheet with Ctrl+A, or click the corner above row 1.
2. Double-click any column boundary in the header row.
3. Every column sizes itself to its contents.

If one column becomes very wide because of a single long description, set its width by hand instead and let the number columns AutoFit.

Changing the font size has the same effect in reverse. A converter that set a large font on a header or total row can push those numbers past the column width. Setting one font size for the sheet often clears hashtags on its own.

## Negative dates and times behind hashtag cells

When widening the column does nothing, the cell probably holds a date or time that is negative. Excel's default date system has no way to show a date before its starting point, so a negative date displays as hashtags at any width. The Microsoft guide linked above says to keep dates and times positive when using the 1900 date system.

Negative dates appear in converted sheets in two ways:

- **Subtraction the wrong way round.** A formula such as `=A2-B2`, where A is an earlier date than B, returns a negative number formatted as a date.
- **Amounts formatted as dates.** If a converter or an earlier paste applied a date format to a column of amounts, every withdrawal is a negative date. Change the format to Number or Currency and the amounts reappear.

The second case hints at a related mix-up where Excel read text as dates to begin with. [Stopping Excel from changing numbers to dates](/blog/excel-changing-numbers-to-dates) covers why that happens. If the dates themselves are wrong, such as a month and day swapped, [fixing converted dates that are wrong in Excel](/blog/converted-dates-wrong-in-excel) is the place to go.

For a real date difference, wrap the formula so it cannot go negative, for example `=ABS(A2-B2)`, and format the result as Number, because a count of days is not a date.

## Long amounts and decimals that fill a hashtag column

A value can be too long for a column you want to keep narrow, often because it shows more decimals than it needs or uses a long date format. Shorten what the cell displays rather than widening it. Fewer decimals or a short date format makes the value fit in the same space.

Three ways to do that, from the same Microsoft guide:

- **Decrease decimals.** On the Home tab, choose Decrease Decimal until the value fits. The stored value keeps its full precision.
- **Use a short date.** A long date such as "Wednesday, March 4, 2026" needs much more room than "3/4/2026". Pick Short Date from the number format list.
- **Shrink to fit.** In Format Cells, on the Alignment tab, tick Shrink to fit. The font gets smaller until the value fits the column.

Converted amounts sometimes carry many hidden decimals from a calculation, such as 14.999999. Rounding them with `=ROUND(C2,2)` both fixes the display and removes a source of sums that are a cent off.

Very long numbers such as account or reference numbers are a separate case. Store them as text, because Excel keeps only 15 significant digits of a number.

## Are hashtags in a cell ever a real error?

Hashtags alone are a display message, but a value that starts with # and ends in a word is a real error. #VALUE!, #REF!, #NAME? and #N/A mean a formula failed, and widening the column will not help. Cells that hold text beginning with # are a third case: they are just text.

How to tell them apart:

| What you see (examples) | What it is | What to do |
| --- | --- | --- |
| ##### | Display message | Widen the column or check for a negative date |
| #VALUE! | Formula error | Check the inputs, often text where a number belongs |
| #REF! | Formula error | A referenced cell was deleted |
| #N/A | Lookup found nothing | Check the lookup value and range |
| #4417 Online payment | Text from the PDF | Leave it, or split the reference into its own column |

The last row is common in statements, where a check or reference number prints with a # sign. If that reference and the description landed in one cell, a split helps. In Excel, Text to Columns does it; if you use Apple Numbers, [splitting a column in Numbers](/blog/split-column-in-numbers) covers the same job there.

## A three-check routine for hashtag cells in converted sheets

Three checks, in order, resolve almost every hashtag cell in a converted file. Each one takes seconds, and each rules out a cause before you move to the next. Work on the whole sheet at once rather than cell by cell.

1. **Widen.** Select all and AutoFit the columns. If the hashtags go, you are done.
2. **Check the format.** Click a remaining hashtag cell and look at the number format on the Home tab. If it says Date or Time on a column of amounts, set it to Number.
3. **Check the value.** Look at the formula bar. A negative result from a date formula needs the formula fixed. A very long value needs fewer decimals or a short date format.

If the sheet came from several PDF pages on separate tabs, run the routine on each tab, or first [combine the pages onto one sheet](/blog/convert-pdf-to-excel-sheet) and run it once.

FastBankConvert is built to put statement dates, descriptions, amounts and balances in their own columns. It is getting ready to open; ask for trial access at [Get started](/get-started).