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?
gls858 - 07 Sep 2006 22:09 GMT
> 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
Elkar - 07 Sep 2006 22:14 GMT
Your column probably isn't wide enough to display the number on the screen.
Try increasing the width of the column.
HTH,
Elkar
> 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?