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

R

Raja

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.
 
R

Ray A

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. Copy>highlight the range of
"numbers" in the check book>paste special>multiply.
HTH
 
Top