How to Display Date and Time as per User Preference in Excel Template

Summary:

Not getting data as per the user general Date Format/Timezone preference in EXCEL template for BIP report

Template build in RTF, is working fine as per User Preference time zone, we referred Oracle White Paper as well.
But not working it for Excel Template.
Please help if there is some guidance for Excel Template as well.

We used query in DM to get as per preference, it's working for Excel but only thing is that we can't convert to DD-MON-YYYY format even after setting date format in user preference. If any idea - How to make it in DD-MON-YYYY, that is also fine.