Protected by Copyscape Web Copyright Protection Software

Search This Blog

Thursday, March 13, 2014

How to display the numbers start with zero in Excel?


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>

No comments:

Post a Comment