This is most likely your answer:

You're experiencing the "text bug"!

Format the cell(s) to "General".


There seems to be a quirk (bug), where in a Text formatted cell of more then
approximately 256 characters, you'll get the ###'s.


Stranger yet, if you keep typing, the true text *returns* when the character
count exceeds 1024.


General format should work for the "in-between" character count.



--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Andmor" wrote in message
...
I do not want to expand the cell as my comments are quiet long.
They appear just fine in some cells but not in others.
All the text is there and can be read but if I format the cell from
general
to text that's when it changes it to ####.
--
A.


"PCLIVE" wrote:

At the top of your sheet, double-click between the two columns with the
column that has the #### on the left. For example, if cell C5 is
displaying
####, then double-click on the line between C and D at the top of your
sheet. This should automatically widen the column as necessary in order
to
display the full contents.


"Andmor" wrote in message
...
I am entering comments on student performance.

The other cells that i have filled in are quite long and have the text
appear just fine without making the colums bigger.
--
A.


"John" wrote:

Have you tried to make the column wider?

What text are you entering?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Andmor" wrote:

I have been entering text into cells formatted for text.
That is until I have reached some cells that are formatted for text
but
the
text comes out ####. Any suggestions?
I even tried to apply the formatting from a cell where the text
appears
correctly but have had no success.
--
A.