Return
-
Title
How to format numeric fields when query result is exported? -
Description
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.
-
Resolution
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.