how to calculate the sum of the data copied from the net?
 

i hav copied my bank accounts to the excel sheet from internet, now i want to
add(sum) of my receivings and payments but the result is "0" value, how can i
handle this problem? thnx for ur prompt reply.

I suspect that your numbers are not numbers at all but were formated as text.
You can check this by entering in a blank cell =isnumber(a1). The results
will be True or False. If false then procede as follows to convert to numbers.
In a blank cell format general and enter1. Copyhighlight the range of
"numbers" in the check bookpaste specialmultiply.
HTH


"Raja" wrote:

i hav copied my bank accounts to the excel sheet from internet, now i want to
add(sum) of my receivings and payments but the result is "0" value, how can i
handle this problem? thnx for ur prompt reply.