Protected by Copyscape Web Copyright Protection Software

Search This Blog

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>