💻 Software
Text cell is displayed with hash characters
Fresh5 days ago
Mar 15, 202651019 viewsConfidence Score0%
0%
Problem
In Excel 2007, I see that the content of some cells are displayed as hash characters (###). These cells are formatted as text and their contents are displayed like this if the number of characters are more than 255. Is there any way to fix this?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Text cell is displayed with hash characters
Low Risk
Cells formatted as text can only handle 256 characters. Anything more and they will be displayed with hash characters (###). To get around this limitation, you can change the formatting of the cell to General. This format has a much larger character…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix