Return
-
Title
Quick Export | Excel Instance | Excel Instance to Excel 2007 adds decimals to numbers -
Description
When I do a Quick Export | Excel Instance | Excel Instance actions to a data grid into Excel 2007, I am getting number results to precision of 0.00000 five places.
I have to manaully clean up his excel export before moving on. How can remove the extra decimals. -
Resolution
WORTKAROUND:
Use Quick Export | File ... | Excel File... insteadRESOLUTION:
In Options | Environment – Grid | Data Type Formatting (Number), one is able to control (format) the number to the desired precision
Setting Number value to Custom = 1 will rid the decimals.