AUTO SUM
 

I USED AUTO SUM TO TOTAL SUBSECTIONS OF A COLUMN. THE FIRST 2 SHOWED THE
TOTAL CORRECTLY: THE LAST 2 SHOW "#####" IN THE CELL. IF YOU PRINT THE
WORKSHEET, THE CORRECT TOTAL PRINTS IN THOSE "#####" CELLS. WHAT AM I DOING
WRONG?

AUTO SUM
 

BJ wrote:
I USED AUTO SUM TO TOTAL SUBSECTIONS OF A COLUMN. THE FIRST 2 SHOWED THE
TOTAL CORRECTLY: THE LAST 2 SHOW "#####" IN THE CELL. IF YOU PRINT THE
WORKSHEET, THE CORRECT TOTAL PRINTS IN THOSE "#####" CELLS. WHAT AM I DOING
WRONG?

You just need to resize that column. Type resize column into help
and then select Change column width and row height. Better explanation
that I can type.

gls858

AUTO SUM
 

Your column probably isn't wide enough to display the number on the screen.
Try increasing the width of the column.

HTH,
Elkar


"BJ" wrote:

I USED AUTO SUM TO TOTAL SUBSECTIONS OF A COLUMN. THE FIRST 2 SHOWED THE
TOTAL CORRECTLY: THE LAST 2 SHOW "#####" IN THE CELL. IF YOU PRINT THE
WORKSHEET, THE CORRECT TOTAL PRINTS IN THOSE "#####" CELLS. WHAT AM I DOING
WRONG?