NUMBERVALUE returns #VALUE error

[cyrilmadrid]

Hello. I am extracting a substring of a text chain. The result I get is a number in text format "1.035", so I use NUMBERVALUE("1.03638") to convert it into a number which I can process.
All worked fine till yesterday I had to reinstall Office, I had a French version and I reinstalled an English version. And what was working no longer works. I guess this may have to see with default decimal character ?
What I want is convert this text number 1.03638, into 1,03638
The formula I use is =NUMBERVALUE(MID(B25;B27+5;7))/100000
and B25 is equal to

{"success":true,"timestamp":1668711183,"base":"EUR","date":"2022-11-17","rates":{"GBP":0.874126,"EUR":1,"USD":1.036382,"CAD":1.381834}}

 

[Rick Rothstein]

Try using SUBSTITUTE to change the dot to a comma and then apply the NUMBERVALUE to that.

 

[cyrilmadrid]

It worked, thanks, I was not aware of SUBSTITUTE, I had tried with REPLACE. Thanks again