Valid from List & Label 11The 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”.