Thread: Text error
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Andmor Andmor is offline
external usenet poster
 
Posts: 25
Default Text error

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.