SUM returning # character in cell

[DeLisa]

I am using the following Sum Equation :
=SUM(M9:M15) if my font is 10 it returns the correct
number which is 14, but the font is smaller than the rest
of the sheet. If I make the font 12 which is the same as
the rest, # is in the cell. Can anyone help with
getting the answer to display correctly in the correct
font? Thanks

 

[Guest]

DeLisa,

The problem is that when you increase the font size, the
number doesn't fit in the column, all you have to do is
increase the column width.
Option A:Select the hole column, right click on it, select
column width and increase it
Option B:Click on the right border on the column and drag
it to increase width.
Option C: Double click on the border of the column, when
the mouse pointer appearance changes.
Regards,
Felipe

 

[Mic]

Felipe's response will work however another option is to
set the columns format to AutoFit selection from the
Format/Columns pull down menu on your toolbar. Using this
the column will automatically adjust to the proper width
to display the result even if your sum source data
changes.
Good luck
Mic

 

[Guest]

-----Original Message-----
I am using the following Sum Equation :
=SUM(M9:M15) if my font is 10 it returns the correct
number which is 14, but the font is smaller than the rest
of the sheet. If I make the font 12 which is the same as
the rest, # is in the cell. Can anyone help with
getting the answer to display correctly in the correct
font? Thanks
.
Most likely your column width is not wide enough.

Increase your column width and the number should display
properly.