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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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. Copy>highlight the range of
"numbers" in the check book>paste special>multiply.
HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Sum in Excel 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
how can i work on information copied off the web on a worksheet? 1
Sum Values from different column 1
What function do I use to calculate a Sum of Digits? 3
calculation help please 1
Copy data from the Status Bar 3
SUM formula results returns 0 value 7

Back
Top