I was able to achieve the desired result by formatting in the sql query using to_char(date_allocated, 'MON-YY') fiscal_period and the excel shows in the desired format e.g., FEB-18

How can I do that ?

I looked but could do not find it. I remember marking an answer correct for my another post some time back.

Since I'm did not post the original question I do not have this option.

I have the same issue can you help. In RTF template I added column to show fiscal period but in the excel output the month is not uppercase. xml tag : <START_DATE>2018-01-01T00:00:00.000-05:00</START_DATE> <FISCAL_PERIOD>JAN-18</FISCAL_PERIOD> whereas the excel output is formatting and showing : 18-Jan I have tried using…

I have excel 2010, which version did you try in ?

The excel being generated is in xls format. Is because of the MS office version the format is giving issue ? Which office version should I get for formatting to work ? Also my BI publisher is bit diff than yours, we are on R12.1 so I'm using BI publisher version 10.1.3.3.0.

I tired both excel and excel2000, same issue.