Displaying Cell Contents
 

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: ############

Displaying Cell Contents
 

hi
have you tried widening your column?
regards
FSt1

"ajones1978" wrote:

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: ############

Displaying Cell Contents
 

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.
--
Kevin Backmann


"ajones1978" wrote:

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: ############

Displaying Cell Contents
 

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

On Wed, 10 Sep 2008 10:33:02 -0700, ajones1978
wrote:

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: ############