Text Format problem

P

P-A Caron

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
 
D

Duke Carey

Try putting some line breaks (Alt-Enter) into your text every 200 or so
characters
 
G

Gord Dibben

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
 
Top