Where to find it

Open the Table Wizard and go to step 5 (Modifications). Under Data Manipulation › Data Format, click Add new Data Format and choose the part of the table with Select Element & Range, usually a column. Then pick the Data Type of the values; the Transformation options for that type appear next to it.

On the product list from Tutorial 1, the rule above turns the Last order column into day/month/year:

The header cell "Last order" is not a date, so it stays as it is. Values that cannot be read as the chosen type are always left unchanged, and empty cells stay empty.

Dates

Choose Date as the Data Type and one of the Date Formats. Using 2 September 2026 as the example:

Which dates can be read

The format you choose is the output. The input can be any common way of writing a date:

Month and weekday names are always in English.

Numbers

Choose Number and set:

• Decimals: 0 to 10. The number is rounded to that many decimals.
• Decimal point: Comma (,) or Period (.).
• Thousands separator: Comma (,) or Period (.).

Numbers with both a thousands separator and decimals are recognised either way round. A comma alone, as in 12,50, is ambiguous and the cell is left unchanged. If a column uses the comma only for decimals, turn it into a period with a replacement rule (Find Text ,, Replace With .) and the number format can do the rest. Replacements run before formats, so both rules can sit in the same ruleset.

Currency

Currency has the same three options as Number, plus the Currency symbol (€ by default) and the Currency symbol position: Before amount, After amount, or Do not display symbol. A symbol that is already in the cell is recognised and not doubled.

Text

Choose Text and one of the Text Transformations:

The transformations work with accented and non-Latin letters too.

Things to know