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

[Guest]

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?

 

[kurtech via OfficeKB.com]

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.

 

[Dave Peterson]

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

 

[Guest]

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)