web page numbers

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

Guest

when i down load my visa statement from the internet how can i add the numbers.
when i use the =sum to add it i only get 0
The numbers are in the right colum, but will not add up.
 
Hi i tried the clean up special paste & reformat cells but it still doesnt
add. any other suggestions
 
try to find out what are the extraneous items in the cell
for that you need pearsons addin
cellview (you can get it in google searach)

there may be nonprinting items in the cell
TRIm function will remove only leading and final spaces and not other items.
in vba TRIMALL function(Davsid Mcritche) will be useful

http://www.mvps.org/dmcritchie/excel/join.htm

when data is downloaded into excel from a webpage it is always a pain
 
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

Amazon not accepting Visa Credit Card for payment from January 2022 20
Adding multiple numbers in one cell 16
Excel How to add numbers in same cell? 2
Sum number range ignoring numbers formatted as text 0
help with adding up hours and mins please 3
adding/omitting/all the values prior to todays date 2
Time Sum in Excel 1
Add multiple values on table based on listbox 0

Back
Top