How to calculate data which is from web query

[YavuzAkbay]

I got stock price data (Yahoo Finance) from web query. When I click refresh it changes theres no problem about that but problem is I cant include that data in my calculations. For example lets say I pulled Tesla price and I want to multiply that price with 5, when I try that it says result is 5. I tried =B2*5 and =Product neither them work. Can't I include them in my calculations?

 

[YavuzAkbay]

All things point to the value being recognized as a text value, instead of a numerical value . . .

1) The value in H5 is left-align instead of right-aligned within the cell.
2) The formula in I5 ignores the value in H5 and returns 1,74, instead of 189,68 (rounded to two decimal places).
3) The other formula in I4 returns the correct result.

So I'm surprised that my last suggestion did not work. Just to be sure that you're doing things right, try the following . . .

1) On the worksheet, select cell H5, which contains the value $109,01.
2) On the Ribbon, under the Home tab, in the Number group, select the Currency format.
3) Re-enter 109,01 in cell H5, and press ENTER.

Does this help?

I turned them both B2 and H5 to currency then write it down again but it doesn't work. As you can see when I turned B2 to currency it went a bit right but still not working.

 

[Domenic]

But I see that you're still using the period ( . ) instead of the comma ( , ) for the decimal separator. So, instead of entering 106.32 with a period, enter 106,32 with a comma.

Does this help?

 

[YavuzAkbay]

But I see that you're still using the period ( . ) instead of the comma ( , ) for the decimal separator. So, instead of entering 106.32 with a period, enter 106,32 with a comma.

Does this help?

I change it to comma but when I refresh pages its instantly turns period again. And tried it too but that's not working.

 

[Domenic]

The data that you're downloading from Yahoo uses the period ( . ) as the decimal separator. But, as you can see, since your version of Excel uses the comma ( , ) instead, those numbers are being recognized as text values instead of numerical values, and so they are left-aligned within the cell instead of right-aligned.

So, you either need to manually enter 106,32 into your cell I5 or, if you're using a formula to return the value from your downloaded data, you'll need to amend your formula so that it replaces the period with a comma and converts it into the form of a numerical value (ie. =SUBSTITUTE(B1,".";",")+0 )