Facing Issues while exporting to EXCEL

[#1]

Hi,

  I am facing a issue while exporting detail data with date fields to excel.

  1) I had formated date field as 'MM/DD/YYYY' in script level.when i am exporting the same to excel. i am seeing the date format as "CUSTOM' in excel instead of "DATE".

    2) And even iam getting the excel out put in compatible mode. which users doesn't want.

   Can any one suggest me on above 2  issue