How to avoid the trimming of leading zeros in XML Publisher Template with Excel output Format
When the XML Publisher creates the Excel output file with fields having leading Zero, when the output file is opened in the Excel Format The leading zeros in the will be automatically lost by the Excel. Excel treat the number in character format as number, we need force excel to treat this value as character and not as numeric value. In my case the tag 01007926 When opening in Excel Format, all i can see is 1007926 . During XML template design, Instead of the using the tag use = " < ? XX_INVOICE_NUM ? > " Please remove spaces. They are only there for the purpose of posting in this blog It wraps the value with double quotes. Now Excel treat value as character and doesn't trim the leading zeroes of value. I found the solution from this link http://peoplesoftlearnings.blogspot.com/2010/04/how-to-avoid-trimming-of-leading-zeros.html