##

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

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.



"Tracy" wrote in 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

-----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.

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

-----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.
.

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.



"Tracy" wrote in
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


.