View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How to show real text insted #

Patrice

Format the cell to General.

Excel has a problem with 255-1024 characters if formatted to Text.

Also, you cannot place any more text in merged cells than you can place in a
single cell.


Gord Dibben MS Excel MVP

On Wed, 7 Jun 2006 07:42:02 -0700, Patrice
wrote:

Hi,

I have 2 cell merged. When I have more then 255 caracters Excel show ###.
How to force Excel to show thw text?

Tank's

Patrice