View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
TD TD is offline
external usenet poster
 
Posts: 29
Default A cell displays many ###'s instead of the text data.

Thank you Thank you Thank you! I've been battling with this problem forever.
You'd think this w/b included in Help for Excel--it's a pretty basic problem.

"Gord Dibben" wrote:

If widening the column does not help.........

Excel has problems with cells that are formatted as Text when the number of
characters reaches 250 or so.

Format the cells as General and see if that helps.


Gord Dibben Excel MVP

On Thu, 20 Jan 2005 08:15:04 -0800, BelAir
wrote:

Cell is formatted to wrap. Surrounding cells are ok.

How do we display the text?