importing numbers from html-charts

  • Thread starter amsterdam-quick
  • Start date
A

amsterdam-quick

How can I select numbers from a HTML web-based financial chart (I.E. the
Gainskeeper type used by Scottrade and E-Trade), copy a single column and
import it into EXEL with PASTE SPECIAL and then add the entries without
getting the answer "0" and/or the error code: #VALUE! ?

Apparently the numbers must be stripped of previous formatting, but how? It
is possible just to enter one number at a time and reformat to "text", then
add them but it is infinite laborious. A thousand thanks! What is the secret
to select columns in the above charts?
 

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

Macro to change position of chart labels on line chart 1
Getting line on line chart to display after creation from Pivot Table 8
Can you create charts for non-adjacent columns of data in XL2007? 1
Importing data from Access and creating statistics and a pie chart 1
Pie Chart 0
import dynamic info from web Excel 2007 0
how to create a chart from the source which does not have explicit numbers 5
Importing Data and Creating Charts from Spreadsheet 3

Top