That worked, I'm not sure what it is but it worked
Thanks

"Harlan Grove" wrote:

CK wrote...
I was trying to figure out why my phone bill tripled this month so I copied
and pasted the list of my alleged calls int an excel spreadsheet. when I
tried to sum the column with the per call charges in it it is always zero.

ie. in cell h235 I enter "=sum(h4:h234)" without quotes. The result is
always zero. It doesn't matter whether I keep the source formatting or match
destination formatting or change the formatting to number under "format
cells." None of the paste special options are useful either. Also if I set
the formula to say "=h34" it will correctly show the value from that cell.
I'm at a loss.

Excel thinks your per call charges are all text. Try the following
formula.

=SUMPRODUCT(--SUBSTITUTE(H4:H234,CHAR(160),""))