I have a large workbook in which I have a saved worksheet that is used to
make other identical worksheets. The saved worksheet is working properly in
regards to formulas, leaving cells blank, etc. However when I copy this
worksheet to another worksheet in the workbook one column which uses the SUM
function changes from a blank cell to one containing a 0 if there is no data
in any of the fields that it is summing. I cant have this.

I have tried clear formatting only with the result that the 0 just reduces
in size - as does anything in the column that has real results.

Thanks

If a formula evaluates to zero but the zero doesn't display it would seem
you have unchecked "zero values" under Tools, Options, View. You'd need to
do that for every sheet where you wanted this result.

--
Jim
"dpridemore" wrote in message
...
|I have a large workbook in which I have a saved worksheet that is used to
| make other identical worksheets. The saved worksheet is working properly
in
| regards to formulas, leaving cells blank, etc. However when I copy this
| worksheet to another worksheet in the workbook one column which uses the
SUM
| function changes from a blank cell to one containing a 0 if there is no
data
| in any of the fields that it is summing. I cant have this.
|
| I have tried clear formatting only with the result that the 0 just reduces
| in size - as does anything in the column that has real results.
|
| Thanks
|
|

Thanks Jim - I now only have 78 worksheets to make this change on.......fun,
fun, fun.

"Jim Rech" wrote:

If a formula evaluates to zero but the zero doesn't display it would seem
you have unchecked "zero values" under Tools, Options, View. You'd need to
do that for every sheet where you wanted this result.

--
Jim
"dpridemore" wrote in message
...
|I have a large workbook in which I have a saved worksheet that is used to
| make other identical worksheets. The saved worksheet is working properly
in
| regards to formulas, leaving cells blank, etc. However when I copy this
| worksheet to another worksheet in the workbook one column which uses the
SUM
| function changes from a blank cell to one containing a 0 if there is no
data
| in any of the fields that it is summing. I cant have this.
|
| I have tried clear formatting only with the result that the 0 just reduces
| in size - as does anything in the column that has real results.
|
| Thanks
|
|

Right-click and "select all sheets" before going to ToolsOptionsView


Gord Dibben MS Excel MVP

On Wed, 8 Oct 2008 15:14:03 -0700, dpridemore
wrote:

Thanks Jim - I now only have 78 worksheets to make this change on.......fun,
fun, fun.

"Jim Rech" wrote:

If a formula evaluates to zero but the zero doesn't display it would seem
you have unchecked "zero values" under Tools, Options, View. You'd need to
do that for every sheet where you wanted this result.

--
Jim
"dpridemore" wrote in message
...
|I have a large workbook in which I have a saved worksheet that is used to
| make other identical worksheets. The saved worksheet is working properly
in
| regards to formulas, leaving cells blank, etc. However when I copy this
| worksheet to another worksheet in the workbook one column which uses the
SUM
| function changes from a blank cell to one containing a 0 if there is no
data
| in any of the fields that it is summing. I cant have this.
|
| I have tried clear formatting only with the result that the 0 just reduces
| in size - as does anything in the column that has real results.
|
| Thanks
|
|