I saw this question in Twitter this week:
Anyone know a way to get an Excel cell to take over 255 characters w/o converting to pound signs ###? Wreaking havoc on something I'm trying
Here's an example – in the following screenshot, cells B2 and B3 contain the same long string of characters.
In column A, you can see the identical character counts for the adjacent cells in column B. In cell B3 the long text simply overflows into the next column, but in cell B2 only the pound signs are visible.
Fix the Problem
Pound signs also show up if a number is too long to display in a cell, and widening the column would fix the problem. However, in this case the cells contain text, not numbers. Widening the column won't help.
In this example, cell B2 is formatted as Text, and you can fix the problem by formatting the cell as General.
To change the format:
- Select cell B2, and on the Ribbon, click the Home tab
- In the Number group, click the dropdown arrow for Number format
- Click on General. (Note: If you look down the list of formats you'll see that Accounting and Text show pound signs, instead of the sample text.)
____________________
This is awesome tips ... thanks so much
I second Dinh's thanks – many thanks!
Thanks!!
Solved my problem. Thanks a lot!
Okay, seriously, if I could kiss you right now I would. MS website was no help at all. Thanks!!!
Thank you so much! I was pulling my hair out working on a customer survey with text in the cells, and it just didn't make sense.
You're welcome! Glad the tip helped you with your customer survey.
Thank you so much for the help!!
It worked - Thank you!
Thank you!!! You saved my day!
You're welcome! I'm glad the tutorial helped you.
Thank u.. Its Fixed.. Thank u...
Thank you! Thank you! Thank you! I was trying all kinds of things until I googled "Excel cell ###" and found your blog.
Thanks for tip! It helped me.
Thank you!!! I was going nuts trying to fix the ####!!
Would Have Taken Me 3 Days to Figure Out! Thank you so much!
Do you have any suggestions for when the General data type also shows ##### instead of my text string? I've tried toggling back and forth between Text and General and it's still #### in the cell.
Jenny, try adding a few lines breaks in the cell (press Alt + Enter)
Thanks heaps !!! save a lot of time