ExcelBanter - How to show real text insted #

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to show real text insted # (https://www.excelbanter.com/excel-discussion-misc-queries/92629-how-show-real-text-insted.html)

Patrice

How to show real text insted #

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

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

All times are GMT +1. The time now is 02:14 PM.