ExcelBanter - Text Format problem

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

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

- - Text Format problem (https://www.excelbanter.com/excel-discussion-misc-queries/23641-text-format-problem.html)

P-A Caron

Text Format problem

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

Duke Carey

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

"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

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

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

All times are GMT +1. The time now is 08:24 PM.