How to Fix Excel Data Showing Compressed, Cut Off, or as ###
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.

- 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.
Ensure you have editing permissions for the worksheet, as protected sheets may restrict you from adjusting column widths or modifying cell formats.
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.
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.
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.
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.

Adjust Cell Number Format
If resizing the column doesn't work, the cell might be applying an overly long or incorrect number format, such as displaying too many decimal places.
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. Open your file in WPS Spreadsheet: Launch WPS Office and open the Excel file containing the compressed or hidden data.
- 2. Select the column: Click the column letter at the top of the worksheet to highlight the affected numbers.
- 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.

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.




