Problem with NUMBERVALUE() and WEBSERVICE() functions

[Oikif]

When I enter the following formula =NUMBERVALUE(WEBSERVICE(“http://download.finance.yahoo.com/d/quotes.csv?s=” & A2 & “&f=l1”)) I’m getting the #VALUE!(Error:Wrong value type). A2 is cell A2. If I remove the NUMBERVALUE I’m getting the right number! I need to convert the return from WEBSERVICE function into a number so I can perform some calculations. If I use the return value from WEBSERVICE I’m getting the #VALUE!. Is there any other way to convert to number the result returned by WEBSERVICE?
I’m using v. 5.4.2.2.

Thank you

[Oikif]

The number displayed, for example, is 19.41. It has just digits and decimal point. To replicate the error enter IBM in A1 and =NUMBERVALUE(WEBSERVICE(“http://download.finance.yahoo.com/d/quotes.csv?s=” & A2 & “&f=l1”)) in A2. if you remove NUMBERVALUE you get 159.53, if you add NUMBERVALUE you get #VALUE!

[robleyd]

Check to make sure there isn’t a trailing space.

[mariosv]

Please use comments not answers for comment.

[cornouws]

one can convert an answer to a comment

[mariosv]

Works for me on the Webservice_Filterxml_functions_test.ods, in this case using FILTERXML() to extract data from WEBSERVICE.

Are you sure the result of WEBSERVICE it’s a number as text with no other characters in.

Edited 20171019

NUMBERVALUE() has three parameters, the second one indicating decimal separator, if your locale use “,” (comma) you must specify it as “.” (dot)

[Oikif]

Yes, it worked. Thank you. I thought the decimal separator defaults to local settings.