Convert output data
I created an ube in jde 9.1. The column item number although its 25 char long field in jde, there are some records in this columns that are stored in numeric.When the report is run in csv we notice that the field has some strange character like 9.21E+..
I researched and found that this is how the excel cells are designed "Default number format in Excel is General therefore you can display up to 11 digits in a cell." Is there any workaround available to get the full value of item number other than prefixing it with some special character?