Thread: Text error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Text error

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.