How many chars do you have in that cell?

Excel limitation:
Column width 255 characters

Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.


For your problem, if your # of chars < 1024, then try:
1) Adjust the column width
2) Wrap text

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================



"Peter Frank" wrote in message
oups.com...
Hi,

I was trying to enter some lines of text into an Excel cell and
although I could enter it, from a certain point on the cell content is
only displayed as ############################### as soon as I exit the
cell. The cell is formatted as text, and the line break option has been
set.

Is there a maximum number of characters per cell in Excel or why do I
get this? Is there any way I can change this?

Peter