View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Why does text look like ###### even when wrap is turned on?

It depends on what you mean by "a fair amount of text". Sometimes it
helps to put in a manual linebreak every now and then (i.e. press Alt-
Enter after about every 60 - 80 characters to force a new line).

Hope this helps.

Pete

On Jul 27, 5:06 am, Sarah wrote:
Well, I guess I already asked it. In "format cells" I checked the
"wrap" option. But still when I type a fair amount of text in, with
spaces, commas, semi-colons, the cell just is filled with one line of
solid #'s. Why doesn't it just show the text? I thought that is what
wrap is supposed to do. It works on other cells with less text.

Thanks....

Sarah