**Aj Hosenfeld:**I'm attempting to export mt4 account history into excel in order to calculate monthly returns. I have no problem getting all of the data into excel. But my problem is trying to perform any functions for numbers greater than 999 or less than -999. So basically any number that should have a comma in it. Has anyone ever seen this problem before? And do you know how I can quickly convert these numbers to a usable format? I really do not want to have to go through and manually key in these numbers.

I cannot see why you would have problems with that unless you are using a different regional format for your Excel sheet. In other words, MetaTrader is producing something like "1234.456" and your Excel is expecting something like "1.234,456" (I am assuming that you are exporting data to Excel via CSV files and not via Binary data).

So, to solve the problem, either set your regional settings to be the same as used by MetaTrader, or change your code so that it outputs the numerical data in the correct format expected by Excel.

Either way, in order to help you further, you will have to show your code. We will need to see how you are outputting the data so as to offer help on how to correct it.

The following might help to serve as an example of a function to output in a different format (code is untested):

// CSV File Parameters

input string

strCSVDelimiter = ";", // Delimiter to be used in CSV File

strCSVDecimal = ","; // Decimal Character to be used in CSV File

...

// Function to output string a Value with different decimal character

string dblToStr( double dblValue, int intDigits = 8 )

{

string strTmp = DoubleToString( dblValue, intDigits );

StringReplace( strTmp, ".", strCSVDecimal );

return( strTmp );

}

Hello,

I'm attempting to export mt4 account history into excel in order to calculate monthly returns. I have no problem getting all of the data into excel. But my problem is trying to perform any functions for numbers greater than 999 or less than -999. So basically any number that should have a comma in it. Has anyone ever seen this problem before? And do you know how I can quickly convert these numbers to a usable format? I really do not want to have to go through and manually key in these numbers.

Thanks