##

[Tracy]

Does anyone know when summing a column say from cells h4-
h60, why I keep getting a ## for the sum? There is one
cell that is a text that should be excluded. Please help

 

[Dave R.]

It maybe the column width is not enough to display the number, try expanding
the column width.

You can automatically fit the width by double clicking on the right-ish edge
of the column header.

 

[Mark V]

-----Original Message-----
Does anyone know when summing a column say from cells h4-
h60, why I keep getting a ## for the sum? There is one
cell that is a text that should be excluded. Please help
.
The reason is that the column size is to small. Double

click on the line between the column with data and the
next column for example if data is in col. A click on the
line in the gray boxes between columns A and B. or as
alternative put your cursor in the cell with ## and then
click format on menu and click column and then width, in
the white box increase column width size.

 

[Guest]

Sorry, for the late feedback, I will try it, thanks.

 

[Guest]

Thanks, Dave.

-----Original Message-----
It maybe the column width is not enough to display the number, try expanding
the column width.

You can automatically fit the width by double clicking on the right-ish edge
of the column header.






.