I suspect the issue is the related to the method the excel file is generated, it is not a true excel file as such and is basically a html file, open the file in a text editor and you will see.
If you are looking to export data you could look at possibly creating a custom script that generates what you are looking for in the correct format, or maybe have a custom app that generates a file though I know it can get messy with the dot and comma so you should keep away from generating a CSV
Thanks for the answer John.
You are correct, when i open this .xls file in notepad i can see something like this:
<html xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if
And i can see all amounts.
In the previous version FDMC, this file was in .xlsx format and it was not readable.
My first idea is to ask from Oracle ER for this issue, maybe they can fix it. I also had an idea to create custom script and export this data, but this makes things more complicated, as you said..
Thanks and regards,