Excel malfunction

O

OG

When I use autosum function some cells fill with a row of hash symbols
although correct sum is visible on toolbar at top. How do I stop this?
 
K

Kevin B

If by hash symbols you mean #, then all you need to do is widen your columns
that display them. The indicate that Excel has a number it cannot display
because the column is not wide enought.

Hope this helps...
 
G

Gord Dibben

Make the column wider. Drag the edge of the column header until the #### go
away.

The "Toolbar on top" is known as the Formula Bar


Gord Dibben MS Excel MVP
 
D

Dave Peterson

Or use a smaller font.

Or even:
Format|cells|alignment tab|check shrink to fit.

or change the format of the cell to general. Excel will drop any decimals it
can to try to make it fit in the cell. (But you'll still see #### if the cell
is too narrow for the integer portion.)
 
Top