0 down vote favorite

I am currently using an XML datasource and I have the date patterns as well as the number pattern set up as dd/mm/yyyy and #,##0.00 respectively, however the data I am pulling from the fields with Xpath is not following this pattern.

an example of a date I am catching is : 2014-02-12 16:00:15 while a price will appear as 40.0000000000.

I also clicked on the aforementioned fields and went into properties, and under pattern I changed it to currency as the numbers refer to prices and set decimals to 2, the problem remains.

I was told that I also needed to change the fields that have numeric values gotten from OPENERP to double instead of string, I did, I was also told to change the pattern to currency with 2 decimals and I did, the problem persists.