Cells formated as text do not always display properly
 

I am using Office XP and Windows XP. I have formatted a column of cells as
text and word wrap is checked, horizontal alignment is Left, Vertical
alignment is Bottom. I use these cells to type a short narrative. The
problem is some of the cells will not display properly, all they show is
######. The row height will expand to hold the text sometimes but not always
but it will still only show ######## instead of the text I typed. If I change
the cell type to General all the text is visible. This does not happed to
evey cell, only some of them. I can type several rows of data with a
narrative and some will show as text and some will show as #### but there is
no rhym or reason as to why. Any suggestions, it's driving me nuts.

Today, in this same group, there was a posting and explanations on what
appeared to be the same subject. Look for a post from Poody, not far from
yours.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Cass" wrote in message
...
I am using Office XP and Windows XP. I have formatted a column of cells as
text and word wrap is checked, horizontal alignment is Left, Vertical
alignment is Bottom. I use these cells to type a short narrative. The
problem is some of the cells will not display properly, all they show is
######. The row height will expand to hold the text sometimes but not
always
but it will still only show ######## instead of the text I typed. If I
change
the cell type to General all the text is visible. This does not happed to
evey cell, only some of them. I can type several rows of data with a
narrative and some will show as text and some will show as #### but there
is
no rhym or reason as to why. Any suggestions, it's driving me nuts.

With cells formatted as text, you'll see ##'s if the length of the text is
between 256 and 1024.

Cass wrote:

I am using Office XP and Windows XP. I have formatted a column of cells as
text and word wrap is checked, horizontal alignment is Left, Vertical
alignment is Bottom. I use these cells to type a short narrative. The
problem is some of the cells will not display properly, all they show is
######. The row height will expand to hold the text sometimes but not always
but it will still only show ######## instead of the text I typed. If I change
the cell type to General all the text is visible. This does not happed to
evey cell, only some of them. I can type several rows of data with a
narrative and some will show as text and some will show as #### but there is
no rhym or reason as to why. Any suggestions, it's driving me nuts.

--

Dave Peterson