Change the cell format to "General".
The hash sign (which Americans call the "Pound Sign" because they never had
real £ signs ...) indicates that "The cell content exceeds the displayable
width", which is 255 characters if your cell is formatted as "Text".
Some people would suggest that if you want to put that much text in a cell,
Excel is the wrong application to be doing this in: a Word table will give
you much more powerful formatting options with that amount of text.
Cheers
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
When entering text (about 120 words) into a cell, after a point the cell stops
resizing, drops back to one line and converts text to hashes
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:
[email protected]