Number Format
About Number Format
Quantemplate requires numbers to use a decimal point rather than a decimal comma. If a thousands separator is present, it must be a comma (e.g. ‘1234.56’ or 1,234.56). Numbers in Excel files are interpreted in the correct format, regardless of any formatting applied in Excel.
With CSV files, values with number formatting applied are treated as text. If the values use number formatting from a different locale, this needs to be converted to the standard format in order to perform calculations.
This operation converts regional number formatting to a Quantemplate compatible format.
Example
Convert a CSV from French number formatting.
Input |
|
|---|---|
Company |
Amount |
Acme |
1 234 568,91 |
BetaCo |
9 876 543,21 |
NewCo |
5 729 827,57 |
Source locale = ‘France’
Output |
|
|---|---|
Company |
Amount |
Acme |
1234568.91 |
BetaCo |
9876543.21 |
NewCo |
5729827.57 |
Using the Number Format operation
To add and configure the Number Format operation:
- From the operations menu, select the Number Format operation. The operation should be used prior to any calculations or numeric validations performed on the data.
- Select the source locale the data originates from (e.g. Poland). A preview of the number format is shown alongside the locale name. Commas are highlighted red, points are highlighted blue.
- Select whether the operation should be performed on all columns in the data, or only selected columns. Non-numeric values will be ignored.