DDE MT4 Excel calculation issue - value error - page 2

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

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! 

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?  

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

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..