Online Documentation for Advanced Data Export for RAD Studio VCL
property UserFormats: TStrings;
The UserFormats property is used in all TQExport4 descendant components, except TQExport4DBF and TQExport4SQL, and allows to set a special output format for any source field. At the same time, the setting of the strings being a part of the property is set in the following way
where <field_name> is the name of one of the source fields, and <output_format> is the output format for this field. For more details, see the Delphi/C++ Builder documentation on FormatFloat, FormatCurrency, FormatDateTime functions. The <field_name> is case-insensitive. Note that there must not be any spaces to the left and to the right of the equality sign.
Use UserFormats property in this and only in this case when you need to set different output formats for two and more fields of the same type, otherwise Formats property should be used.
Note: If you want to add measurement units or any other comment string to format string on export to XLS you need to keep in mind that symbols "d", "e, "h", "m", "s" and "y" are used for formatting purposes. If you need to use these symbols in the format string, add back slash before the symbol (e.g. "", "").
field1 = ###.# kilo
field2 = ##