Not displaying Zero in Excel in Oracle apps

I have to display my XML output in Excel format. I want the output of INVOICE NUMBER column to be displayed as is it is from the data base.

But the problem is if invoice number having zero with prefix then the zero’s are not displaying…

i.e 002345 is displaying as 2345 only (EXCEL)

But this will works fine in PDF output, but its not working for Excel output.
Use below Syntax.


Answer:

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?INVOICE_NUMBER?></fo:bidi-override>

How to change the report heading based on type?

In Ar invoice report Display Credit memo for type credit memo and debit memo for debit memo type invoices.

Solution
---------

For this i took A form field in heading and increase size by ctrl+{ buttons or manually increase size because it is heading.

Then in  that form field write below code.

<?xdofx:if to_char(TYPE)='INV'  then ’TAX INVOICE’else if to_char(TYPE)='CM' then ’CREDIT MEMO’ else  ’DEBIT MEMO’ end if?>

The rtf Look like below...