Hi,
Anybody knows how to prevent XL reporter from truncating the leading zero(s) in the item code?
I had done a XL report where one of the field is to retrieve Item Code. In the report generated, the formula was as below:
=ixDimGet("00100068")
However, when MS Excel display it in the spreedsheet, the item code becomes "100068" where the leading zeros was truncated. The correct item code was supposed to be "00100068". I had tried to change the cell format to "text", "number", "general" and etc, but it doesn't work. Any method to correct the item code display in the Excel spreadsheet?
Thanks,
sianghing