BI Excel Report - Character text is being converted to Date in excel
Hi,
I am creating a BI excel report where the xml data comes from the rdf report. The excel report contains a column of Inventory Item number which is a character field. When I open the report in excel, the field is being converted to date in excel report. For example, the sample item number is
11-01
and in the excel report it's being converted as
Nov-01
. I have used <?xdofx:to_char(INVENTORY_ITEM)?>, but it's not working.
Any suggestion would be very helpful.
Thanks,
Sudheer
0