Normalize one number column

Choose the numeric column and its punctuation

Inspect the table first, then select the column that contains amounts. State the decimal separator and any grouping separator used by that source. A comma may mean a decimal separator in one file and a field boundary in another; those are separate settings.

The converter changes only the selected numeric column. It preserves other cells, including identifiers. Values that do not fit the chosen notation remain available for review instead of being silently interpreted as zero.

Read the issue count

Converted cells and unresolved values describe the transformation of this input, not the accuracy of the original amounts. Inspect the flagged rows before using the download for an import or a total. Use a decimal check when exact text-based decimal arithmetic matters.

Example calculation

Normalize one number column: worked out from the values already filled in the form above.

Inputs

• Table text:

  id;description;amount
  000123;Paper;1.234,50
  000124;Pens;15,20

• Delimiter: ;
• Number column: amount
• Decimal separator: ,
• Grouping separator: .
• First row contains column names: ✓

Result

• Rows: 3
• Columns: 3
• Converted cells: 2
• Values left for review: 0

• id: 000123 · description: Paper · amount: 1234.50
• id: 000124 · description: Pens · amount: 15.20

Related tools

Remove repeated table headers · Export a table as text-safe XLSX · Check an exact decimal total