# NumFormat

_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](setcol.md) directives.

The first variation above uses the pre-defined [NUMFMT\_xxx symbols](number_formats.md). For example:

NumFormat=NUMFMT\_NUMBER\_SEP\_D2

The second variation specifies a mask according to the specification for the mask parameter of the [SetCol](setcol.md) 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.