User uses Tools | Options | Grid to change the "Number Format" setting to Fixed-Point (F) option in order to show Float numeric columns in Results tab with only two decimal places. However, when data is exported to Excel, these numbers show the original number format with more numbers after the decimal point.
Modify query statement to format numeric columns to specify number of decimal places. For example, in Oracle use TO_CHAR, in Sybase use ROUND function, etc.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy