### signs!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Sometimes I can fit a lot of text in a small font into a cell. Other
times when I try to fit the same amount of text into another cell, all I end
up with on the screen are # signs. Thanks for the help!!
 
Hi
this just indicates that the column width is not sufficient. Just
extend the size of this column
 
Format the cells for General:

Select the cells
Choose Format>Cells
Select the Number tab
Select the General category
Click OK
 
Your column needs to be widened if you get a ######## in your cell. To
do this, go to

Format
Column
Width

and adjust your column width.

Hi,
Sometimes I can fit a lot of text in a small font into a cell. Other
times when I try to fit the same amount of text into another cell, all
I end
up with on the screen are # signs. Thanks for the help!!
Click to expand...
 
Tara

If it is not a column width problem may be........

There seems to be a problem with text length between 256-1024 (0-255 and 1025+
work ok).

The bad news is that this is the way Excel works.

Re-formatting the cell(s) to General usually fixes the problem of the
#######'s

Gord Dibben Excel MVP
 
If it is a column width issue, a shortcut to change the width is to move
your mouse between the top of the problem column and the next column.
Your mouse will change into two arrows pointing away from eachother and
all you need to do is double-click. The column will automatically adjust
to the width that it needs to be.
 
Back
Top