New May 2025
NumFormat=NUMFMT_xxx
NumFormat=mask
Specified in the [FORMAT] section of the CSV2XL.INI file, NumFormat defines the default format to use for columns that are purely numeric (instead of NUMFMT_GENERAL) and are not otherwise defined via SetCol directives.
The first variation above uses the pre-defined NUMFMT_xxx symbols. For example:
NumFormat=NUMFMT_NUMBER_SEP_D2
The second variation specifies a mask according to the specification for the mask parameter of the SetCol directive. For example:
NumFormat=##,###,###.00;[Red]##,###,###.00
Note that for columns that are purely numeric, but which you want to leave unformatted such as account numbers, zip codes, etc., you can use the ColTitleTextRegex directive to exclude them from the NumFormat format based on the column title.
History
2025 May, A-Shell 7.0.1772, CSV2XL.SBX 2.2(304): Directive added to CSV2XL.SBX.
