Displaying Cell Contents

A

ajones1978

Why do I have to double click on the contents of a cell in order to view the
text that's written in it? I have already resized the row to accommodate the
text, but it still shows and prints like this: ############
 
K

Kevin B

The # symbol displays in cells when the column width is not wide enough to
display the number in the cell. This has nothing to do with row height, it's
a column width issue. Double click the line between the column letter of the
column with the # character and the one directly to its right to widen the
column to the longest entry in the column.
 
G

Gord Dibben

If it is text and not numbers or negative dates.times, Excel has a problem
with text strings between 255 and 1024 characters when formatted as text.

Re-format to General and you should be OK.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Displaying & Printing cells with lotsa text 2
Auto-adjust row height does not work correctly 2
Setting rows to autofit wrapping text in a cell 1
Text Running Out of Cell 1
Incorpoarting cell contents into a message box 6
Disappearing cell contents 1
Cell shows the last typed text, no matter where it is typed 0
Hide Some Text in a Cell 4

Top