Work with Queries?

[ADB]

Hi again,

One more thing on importing data from internet. I just imported the stock exchange: http://www.iex.nl/stocks/default.asp?beurs=nl&Group=2. that works. Now I want to copy the numbers into my formula, but that doesn't works. It gives an error. I just want to multiply with the number of stocks I have, etc.

Anybody?

Thanks in advance,

Best,

ADB

[Rahul Nagar]

Hi,

Try paste special.
1st paste the data as a txt and then after set the format as number on which column you want to add the formula.

[ADB]

Sorry, I guess I do not understand. So I get the table in excel in sheet 2. The I want cell a4 in sheet one to be the current value of stock AEGON. That works so far. But then I want to multiply A4 with A3 which is the number of stock I have. And that does not work...

Thanks!

[Rahul Nagar]

Hi,

Check the attached file and let me know.

[ADB]

Yes that look s more like it! However, now remains the question, how did you do that??

I see 4,540 the whole time, while at your file it says 45400 ??

Appreciate it!