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.
Use Quick Export | File ... | Excel File... instead
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.