mike55 Member Sep 6, 2016 #1 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
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 Sep 11, 2016 #2 mike55 said: 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 Click to expand... One way is to send the value in below format New String Value = concat("=",concat('"',concat( ltrim(rtrim([Value to be converted],' '),' '), '"')))
mike55 said: 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 Click to expand... One way is to send the value in below format New String Value = concat("=",concat('"',concat( ltrim(rtrim([Value to be converted],' '),' '), '"')))