Thread: Excel; shows a line of # instead of my text in a merged cell.
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Excel; shows a line of # instead of my text in a merged cell.
Chip

See my post for possible third reason when mucho text in a Text-formatted cell.


Gord

On Wed, 28 Feb 2007 14:46:23 -0600, "Chip Pearson" wrote:

That happens for either of two reasons: (1) the column is not wide enough to
display the data, or (2) the cell is formatted for date and/or time and the
cell contains a negative value.

Reply With QuoteReply With Quote