View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
sherroc
 
Posts: n/a
Default what does the # sign mean in a cell

Thanks, Bob, for your help. Changing the cell format from text to general
actually solved the problem.

"Bob Phillips" wrote:

It means that the value is too great to display, so you can widen the
column, or that it is not able to display it, negative time for instance.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"sherroc" wrote in message
...
Why do I see ###### in a cell rather than the text that is there. The

text
shows up in the line across the top but not in the cell itself.