BI Publisher Prevent Excel from suppressing leading zeros

mike55

Member
Is there a way to prevent excel from suppressing leading zeros.


JDE release 9.0
Tools release 9.1.4.3
BIP 11.1.1.5
 

Abhishek Chhajer

Well Known Member
Is there a way to prevent excel from suppressing leading zeros.


JDE release 9.0
Tools release 9.1.4.3
BIP 11.1.1.5


One way is to send the value in below format
New String Value = concat("=",concat('"',concat( ltrim(rtrim([Value to be converted],' '),' '), '"')))
 
Top