Formatting Issues

How to Fix Excel Data Showing Compressed, Cut Off, or as ###

Bushra ParveenBushra Parveen Nov 11, 2026 870 views

Question details

The user needs to fix Excel cells where numeric data appears compressed, cut off, or displays as ### symbols instead of the actual values.

How to Fix Excel Data That Appears Compressed or Shows Half of Numbers
Product
Excel
Device & OS
not provided
Scenario
Viewing or editing an Excel worksheet where cell contents have changed or a new layout causes numbers to display incorrectly.
Observed behavior
Numbers display as ### symbols or appear cut off and partially hidden due to insufficient column width or incorrect formatting.
Before you start

Ensure you have editing permissions for the worksheet, as protected sheets may restrict you from adjusting column widths or modifying cell formats.

Solution 1Recommended

Use AutoFit to Adjust Column Width

The quickest way to fix cut-off numbers or ### errors is to adjust the column width to automatically fit the widest string of data.

Excel uses ### symbols to mask numbers when a column is too narrow. This prevents users from misreading truncated numbers. Expanding the column immediately resolves this.

1
Select affected columns

Click on the column header letter (e.g., 'A') to select the entire column. You can also click and drag across multiple headers if several columns are affected.

2
Use the AutoFit shortcut

Hover your cursor over the right boundary line of the column header until it turns into a double-sided arrow, then double-click. The column will automatically expand to fit the data.

3
Use the Home ribbon

Alternatively, go to the 'Home' tab, click 'Format' in the Cells group on the right side of the ribbon, and select 'AutoFit Column Width' from the dropdown menu.

Use AutoFit to Adjust Column Width
Tip: You can select the entire spreadsheet by clicking the triangle in the top-left corner (between row 1 and column A) and double-clicking any column boundary to AutoFit all columns at once.
Efficient Spreadsheet Management

Easily Manage and Format Spreadsheets with WPS Office

Fixing formatting errors like cut-off numbers or ### symbols is incredibly intuitive in WPS Spreadsheet. It offers full compatibility with Microsoft Excel formats and provides one-click tools to adjust layouts effortlessly.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the Excel file containing the compressed or hidden data.
  2. 2. Select the column: Click the column letter at the top of the worksheet to highlight the affected numbers.
  3. 3. Apply AutoFit: Double-click the column boundary or go to the Home tab and click 'Row and Column' > 'AutoFit Column Width' to reveal the numbers.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsOne-click AutoFit for rows and columns to fix display issues instantlyFree, lightweight, and easy-to-use alternative to Microsoft OfficeBuilt-in advanced formatting tools for professional data presentation
microsoft office alternative - wps office

Frequently Asked Questions

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

Excel displays ### when the column is too narrow to display the entire number, date, or time. Unlike text, which can spill over into the next empty cell, numeric data must be fully visible to prevent misreading, so Excel masks it with ### until the column is widened.

How can I fix compressed data without changing the column width?

If you cannot widen the column, you can shrink the text to fit. Right-click the cell, select 'Format Cells', go to the 'Alignment' tab, and check the 'Shrink to fit' box. The text size will automatically reduce to fit inside the current cell width.

Will hiding and unhiding columns fix the cut-off display?

Hiding and unhiding columns typically restores them to their previous width. If the width was already too narrow, unhiding won't fix the ### error. You will still need to apply the AutoFit Column Width feature after unhiding.

Why are numbers displaying as scientific notation instead of the full number?

Excel automatically converts numbers with 12 or more digits into scientific notation (e.g., 1.23E+11) to save space. To display the full number, format the cell as a 'Number' with zero decimal places, or format it as 'Text' before typing the number.