Excel Export: Formatting Numerical Values

Valid from List & Label 11
The formatting of numerical values in the Excel export is determined by the XLS.ConvertNumeric setting.

By default (XLS.ConvertNumeric=1) the formatting is set within the designer/project file. You can set the number of decimal places for all unformatted numerical values in the Project > Options dialog. If the number of decimal places is set to '2' here, all numerical values will have 2 decimals in the resulting Excel file as well.

If you'd like to prevent your numerical column from being formatted in this way, use the following switch:

Now only those columns that have not been formatted explicitly by a function (ex. Str$(Price,0,0)) will be converted.

Alternatively you can choose to handle numbers like characters by setting XLS.ConvertNumeric to “0”.

Related articles:

IDKBTE000656 KBTE000656