Formatting Issues

How to Fix Excel Displaying Hash Symbols (####) Instead of Numbers

Olivia MillerOlivia Miller Nov 10, 2026 872 views

Question details

The user needs to resolve an issue where Excel cells display a series of hash symbols (####) instead of the actual calculated numbers or dates.

How to Fix Excel Displaying Hash Symbols (####) Instead of Numbers
Product
Excel
Device & OS
not provided
Scenario
Entering data or calculating formulas involving numbers, dates, or times.
Observed behavior
The cell displays '####' instead of the expected numerical value, even though the underlying formula calculates correctly.
Before you start

Ensure you haven't accidentally deleted any underlying data. The '####' error usually only indicates a visual display issue, meaning your original numbers and formulas are still intact and calculating properly behind the scenes.

Solution 1Recommended

Widen the Column to Fit the Data

The most common reason for hash symbols is that the column is too narrow to display the entire number or date format. Expanding the column width will instantly reveal the data.

1
Locate the column

Identify the column header (the letter at the top) containing the cell that displays the '####' symbols.

2
AutoFit the column width

Hover your cursor over the right boundary of the column header until it turns into a double-sided arrow. Double-click the boundary to automatically adjust the width to fit the longest entry in that column.

3
Manually drag to widen

Alternatively, click and drag the right boundary of the column header to the right until the number or date is fully visible in the cell.

Widen the Column to Fit the Data
Data Intact: Once the column is wide enough, the hash symbols will disappear, and your accurate data will be displayed.

Easily Manage Spreadsheets and Formatting with WPS Spreadsheet

WPS Spreadsheet offers an intuitive interface for fixing cell display issues like the '####' error. It is highly compatible with Microsoft Excel formats and provides easy-to-use tools for adjusting columns and formatting cells.

  1. 1. Open your workbook: Launch WPS Spreadsheet and open the file showing the hash symbol errors.
  2. 2. AutoFit column width: Double-click the right edge of the column header to instantly adjust the width and reveal the hidden numbers.
  3. 3. Adjust cell format: Right-click the cell, select 'Format Cells', and modify the number of decimal places or date format to fit the cell perfectly.
Fully compatible with Microsoft Excel (.xlsx, .xls) files.Quick AutoFit features to instantly fix '####' column width errors.Free and lightweight, running smoothly on Windows, Mac, and Linux.
microsoft office alternative - wps office

Frequently Asked Questions

Can I make the text shrink to fit the cell instead of widening the column?

Yes. Right-click the cell displaying '####' and select 'Format Cells'. Go to the 'Alignment' tab and check the 'Shrink to fit' box. The text will automatically reduce in size to fit within the current column width, eliminating the hash symbols.

Why do I see #### when I type a very long number?

If you type a number longer than 11 digits, it may exceed the cell's default display capacity. To display a full long number (like a credit card or ID number) without converting to scientific notation or '####', change the cell format to 'Text' before typing, or type an apostrophe (') before the number.

Does printing the spreadsheet show #### or the actual numbers?

If the spreadsheet displays '####' on your screen, it will also print exactly as '####' on paper. You must widen the columns or adjust the cell formatting before printing to ensure the actual numbers appear on the printed document.