Wrong text format after a MT4 download in Excel

 

I have a fxcm metatrader system and using the mt4 version. The download is okay but I am facing problems with the format in my Excel sheet. When the value is above 1 like the eurusd the input has to be divided by 100.000 to achieve the right value. When the value is less then 1 like the usdcad then the input has the right value but it is formatted as a textvalue formula and it is impossible to do arithmetics on such a figure. The excel sheet generates a failure message like #value!. I hope there is a simple solution.

 

Well, try this : open your historical data on a chart, press Ctrl + S to save it and see if excel can open it.

 
phi.nuts:

Well, try this : open your historical data on a chart, press Ctrl + S to save it and see if excel can open it.



Sorry , but it is not a solution.