How did I break the cell display limit?

S

s&th

If there is anyone out there who can help with this, I would be most,
most grateful. Here's the facts:

- I'm working in a MS Excel worksheet.

- I am aware of Excel's 255-character-per-cell display limit. (As I
understand it, each cell can hold up to 32,000 characters, but will
only display/print 255 characters.) This is a major pain in the
petunski, as most of my cells contain more than 255 characters.
Therefore, most of my spreadsheet shows cells that look like this:
###############. I have to look in the formula bar to see the actual
contents of each cell.

- In cell C35, I have 1,055 characters - all of which are displayed in
the cell. This particular cell also prints the actual contents of the
cell. This is the only cell that behaves in this manner.

- I have checked the properties of my cells under FORMAT > CELLS, and
the properties are identical for all the cells.

Does anyone have any idea why this particular cell is being so
generous? It would be marvelous if I could get the rest of the cells to
behave the same way, but I can find nothing in the online help to
indicate that this is possible. I have Googled around for an answer,
and I find nothing.

I'm tearing my hair out over this. Can anyone help? Thanks in advance
for any advice.

=

sweet & tender hooligan
 
G

Gord Dibben

Excel cells can hold up to 32,767 characters but will display/print about 1024
depending upon Font.

You can get more than 1024 by breaking it up using ALT + ENTER at spots within
the text.

The ########### cells are probably formatted as Text.

Try re-formatting as General

Gord Dibben XL2002
 
Top