attached is an Excel file that illustrates the problem.
Cell A1 contains text, but even after
1. activating wraping and
2. expanding the cell width to wider than the lenght of the text
I can only see pound signs.
Does anybody know how I can make the text visible?
Last edited by dschmitt; 04-08-2010 at 10:18 PM.
The text is visible to me. Very odd you cannot read it.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
do you see it in cell A1?
I can see it in the formula bar but not in cell A1.
a college of mine also can not see the text in Cell A1.
We are using Office Excel 2007.
hi,
Perhaps try:
- changing the cell format from "text" to "General" or,
- limiting the text in a single cell to 1024 characters, your example has 1507 characters (see http://support.microsoft.com/kb/211580) or
- "Add an Alt + Enter linefeed every 100 or so characters." (see http://www.pcreview.co.uk/forums/thread-3981238.php or http://www.thecodecage.com/forumz/ex...ngle-cell.html).
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
Using Excel 2007, all I have to do is change cell A1's format to General and I can see the full text.
Cells in Excel 2003 and 2007 can hold over 32,000 characters. Excel 2003 will only show you 1024, and Excel 2007 will show you quite a bit more.
Hi Dschmitt
Thanks for the feedback/rep & marking the thread as solved
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks