In your Excel template, format the cell so that Category=Number, decimal places=2. All OOTB (Excel/Html) NX9 templates have been reconfigured (in Excel) with proper formats assigned to the cells.
Sir thanks, but actually know you said that, I have an issue, when I select the Operation List format (HTML/EXCEL), I only got the HMTL format, how can I do to get the EXCEL format? Do I have to config something else to run the office app and get the info in Excel format?? What Did I do wrong?
Just to clarify, controlling the number of decimal places output in Excel and html required formatting changes to the out-of-the-box templates as well code changes in tcl. In order to control the number of decimal places output in both Excel and html, you must run NX9 using NX9 templates. Reformatting the template cell prior to NX9 will affect only the Excel output.