View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Zaphod42b Zaphod42b is offline
external usenet poster
 
Posts: 3
Default # sign appearing in text boxes, Why?

That workes, but takes me out of my page size settings. The next option
worked great, thanks for the help

"Kevin B" wrote:

The # symbol indicates that the column is not wide enough to display the
number within the cell. Widen the column to correct.
--
Kevin Backmann


"Zaphod42b" wrote:

When I have a large text box (10 lines of wrapped text) excel shows a series
of # instead of the data. This only occurs when I am outside the cell, when
inside the cell, the text displays correctly. When viewing in Print Preview,
the # appear instead of the desired text.

Why does excel do this (v2003) and how can I get it to stop?

Thanks