Excel has a problem with cells formatted as text when number of characters is
between 255 and 1024(approx)

Format the cells as General.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 10:21:04 -0700, P-A Caron
wrote:

Hello all,

I have some cells formatted as text and when I put 256 + characters I have
the problem that the cell show "############".

How can I fix it without changing the format of the cells?

TIA
P-A