Text changes to hashes

T

Tycoon_Rosie

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
 
B

Bob Greenblatt

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
Is there a question here? Please tell us which 120 words, the attributes
of the cell, exactly what keystroke stops the resizing, and what are
hashes? These things: (#)?
 
J

John McGhie

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]
 
T

Tycoon_Rosie

> Is there a question here? Please tell us which 120 words, the attributes
> of the cell, exactly what keystroke stops the resizing, and what are
> hashes? These things: (#)?
>
> --
>
> Bobgreenblattatmsndotcom
>
Yes, a hash is #. Sorry I can't provide the words as had to change my approach to move on - so also can't provide the exact key strokes. Will make a note next time
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top