Excel output not displaying all '0' digits
Hi,
So I have XML publisher RTF template working fine in Excel output format. One of the fields in the template - 'SHIP_TO_ADDRESS_LINE3', can often be a combination of text and numbers or just one of them, depending on the territory the customer is from.
When it is just text - it displays fine, however when it is just a number and the last digits are 0's, the output is shortened and displayed as '4.01216E+11' instead of the full number '401216000000' - which is what needs to be displayed.
The text form field is set up as type 'regular text' and the form field help text form is simply put as '<?SHIP_TO_ADDR3?>'.