If your data is not real numbers but text, you will get a zero.

Simply re-formatting will not change these "numbers".

Format all to General.

Copy an empty cell.

Select the range of "numbers" and editpaste specialaddokesc

Should now be good to go.


Gord Dibben MS Excel MVP

On Thu, 22 Oct 2009 12:50:09 -0700, canole
wrote:

I am adding a subtotal to a report. All of my subtotals equal 0.
3.50 700 The Responsible Manager - FFS Class 1
4.00 703 Ethics & Employee Conduct - FFS Class 4
4.00 704 Managements Kitchen Sink - FFS Class 5
0
The formula looks right =SUBTOTAL(9,C2379:C2396)
I've tried to reformat the cells. I just don't get it. Can anyone help?