is text and cannot be changed to a number

[robsonKun]

Hello,

In the first cell, everything goes in, and in the second cell, I get an error.


"Parameter 1 of the MINUS function parameter requires a number." 0.352777 "is text and cannot be changed to a number.
I have tried to change regional setting for GB, next for US but that wasn't working. Im from Poland.

I import data. C2 is =IMPORTDATA("https://cryptoprices.cc/BTC/")
D2 is working I mean =(C2-B2)/B2

But next cell not idk why

I think it's something related to a period / comma in a number. How to get it to calculate correctly.

please help

Thx

 

[jasonb75]

You could try

=(SUBSTITUTE(C3,".",",")-B3)/B3

Note that you will need to translate SUBSTITUTE to the equivalent in your own language. You may also need to change the first 2 commas (not the 3rd) to semicolons.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: "is text and cannot be changed to a number."
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[ajm]

Multiply by 1

 

[jasonb75]

Multiply by 1

That will not work because the content of C3 is not a valid as a number with the OP's regional settings. If it was then their existing formula would have worked correctly.