View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default 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?