Too much text in one cell

[Daniel Wolf]

Hello,

When I have a lot of text in one cell, Excel just displays "############"
instead of the text. How can I change this?

 

[Frank Kabel]

Hi Daniel
you may try entering some manual line breaks with 'ALT+ENTER). Though
have a look at the Excel help file under 'Specification'. There is a
maximum of characters which can be displayed in a cell!

 

[Kim]

If you widen your row/column the text will display normally.

 

[Gord Dibben]

Daniel

Try formatting the cells to General.

Gord Dibben Excel MVP

 

[Daniel Wolf]

Thanks a lot - that worked.

Daniel

Try formatting the cells to General.

Gord Dibben Excel MVP

 

[Gord Dibben]

Thanks for the feedback Daniel.

Gord

Thanks a lot - that worked.