Protected by Copyscape Web Copyright Protection Software

Pages

Search This Blog

Showing posts with label How to display the numbers start with zero in XML Publisher Excel Output in Oracle Applications. Show all posts
Showing posts with label How to display the numbers start with zero in XML Publisher Excel Output in Oracle Applications. Show all posts

Thursday, March 13, 2014

How to display the numbers start with zero in Excel?

Solution
----------

If our value is 098 but in excel it shows 98 because it converts it into number.
I have item number 00675.78. it is a varchar2 column. when i load it in xml and in output excel it is showing 675.78

so to display as it is i used below code in form field.


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