Why does text in a cell appear as a line of '#' symbols?
 

I have typed text into a cell, and when I select the cell, the text is
readable in the upper editor line. However, if you click into another cell,
the original cell displays only '##############'. Word wrap is on, and I
have compared the cell properties of the rogue cell with that of others -
there doesn't appear to be any difference between setup. Extending the
height or width of the cell does not appear to fix it.
Is there any way I can get rid of it?

Why does text in a cell appear as a line of '#' symbols?
 

Kramer wrote:
I have typed text into a cell, and when I select the cell, the text is
readable in the upper editor line. However, if you click into another cell,
the original cell displays only '##############'. Word wrap is on, and I
have compared the cell properties of the rogue cell with that of others -
there doesn't appear to be any difference between setup. Extending the
height or width of the cell does not appear to fix it.
Is there any way I can get rid of it?

Try double-clicking on the right border of the column. It sounds like you're
not expanding the column far enough to include all of the data being returned.
Double-clicking will automatically expand the column to the width necessary.

--
Message posted via http://www.officekb.com

Why does text in a cell appear as a line of '#' symbols?
 

Try formatting the cell as general--I bet it was formatted as Text.

Kramer wrote:

I have typed text into a cell, and when I select the cell, the text is
readable in the upper editor line. However, if you click into another cell,
the original cell displays only '##############'. Word wrap is on, and I
have compared the cell properties of the rogue cell with that of others -
there doesn't appear to be any difference between setup. Extending the
height or width of the cell does not appear to fix it.
Is there any way I can get rid of it?

--

Dave Peterson

Why does text in a cell appear as a line of '#' symbols?
 

What is in the cell - text or numbers & how long id the text?

Try copying a 'good' cell and paste special and select format onto the cell
showing #
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Kramer" wrote:

I have typed text into a cell, and when I select the cell, the text is
readable in the upper editor line. However, if you click into another cell,
the original cell displays only '##############'. Word wrap is on, and I
have compared the cell properties of the rogue cell with that of others -
there doesn't appear to be any difference between setup. Extending the
height or width of the cell does not appear to fix it.
Is there any way I can get rid of it?