Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default importing numbers from html-charts

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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Completely baffled on what should be simple Pat Hughes Excel Discussion (Misc queries) 12 October 23rd 06 08:24 PM
How to put portrait page numbers on landscape charts? OK Soccer Fan Excel Discussion (Misc queries) 2 October 10th 06 03:26 AM
Retain Numbers as Text Format When Importing. xardoz Excel Discussion (Misc queries) 2 June 20th 06 05:16 PM
How do I display html code within a cell? John-Raritan Excel Discussion (Misc queries) 6 October 31st 05 03:59 PM
Checking Winning Numbers in the Lottery. Ann Excel Discussion (Misc queries) 4 May 18th 05 10:55 AM


All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"