DDE MT4 Excel calculation issue - value error - Spreads - MQL4 and MetaTrader 4 - MQL4 programming forum

Carl Schreiber 2015.02.04 20:59 #11

I don't have Excel I have LO and it works the way I posted it.

Daniel Jurnik 2015.02.05 07:45 #12

Problem SOLVED! I saved the excel document in the latest format. It is bad procedure. You have to save the document in 97-2003 format.

Thank you for your help!

Daniel Jurnik 2015.02.05 18:36 #13

Problem is not solved :-( But I know, where is it :-)

I have Excel that use numbers with "," not ".". I know how to replace "," to "." in Excel, but is there any other solution? Without replacing the characters?

Carl Schreiber 2015.02.05 18:49 #14

In LO you can set the the number formate to English (USA)..

bundy71 2022.04.01 10:53 #15

I know this is old tread..

But the solution is to use the =NUMBERVALUE command in Excel to convert us numbers to eu or the other way around.

fx: =NUMBERVALUE(A2,",",".")

Just google the command if you dont know it..

help, i can't uninstall FOREX - Trends, forecasts How to trim to

DDE MT4 Excel calculation issue - value error - page 2