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.