How to show real text insted #

[Patrice]

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

[Gord Dibben]

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 <[email protected]>
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