Numbers and dates
Write the numbers of a column plainly, with one decimal separator and no thousands separators, and its dates in a single format, whatever way each one was written.
The same amount can be written 1,234.50, 1.234,50 € or $1234.5, and the same day 3/12/2026, 12/3/2026 or 3 Dec 2026. A program that reads the file needs them written one way. These two operations do that, in the cursor’s column or in what you select (see How data operations work).
Both open a window that shows a few of the values as they are and as they will be, and says how many cells will change, before anything changes. Values that aren’t numbers, or aren’t dates, are left as they are, and counted.
Reformat Numbers
writes each number plainly: no thousands separators, a - in front if it’s negative, and the decimal separator you choose.
- They are written: how to read them. Automatic reads each column with its own decimal separator, the one the editor lines the column up with (see Numbers, dates and other values), so
1.234,50is a little over a thousand in a column of decimal commas. Choose a point or a comma yourself when a column mixes both, or when1,500is read the wrong way. - Write them: with a decimal point (
1234.56), which is what most programs and databases expect, or with a decimal comma (1234,56). - Keep currency, units and %: without it,
1.234,50 €becomes1234.50and50 %becomes50; with it,1234.50 €and50 %.
The digits are the ones that were written: nothing is rounded, 1.50 keeps its zero and a code like 00123 keeps its zeros too. A number that was in quotes because of its comma loses them when it no longer needs them.
Reformat Dates
writes each date in the format you choose. It reads dates of three numbers separated by /, . or -, with years of two or four digits (31/12/2026, 12.31.26, 2026-12-31), and dates with the month’s name in English (31 Dec 2026, December 31, 2026, 31-Dec-26). A time after the date stays as it is: 31/12/2026 14:30 becomes 2026-12-31 14:30.
- They are written: which number comes first. Automatic looks at each column: a first number over 12 can only be a day, so
13/05/2026settles it for its whole column. When every date of a column could be read both ways (3/4/2026), the window says so and which way it read them: choose Day first or Month first if it guessed wrong. A first number of four digits is always the year. - Write them:
2026-12-31(ISO 8601, the one that sorts as text and that every program reads), day or month first with/,.or-, with the month’s name, or only the month (2026-12) or the year (2026).

Years of two digits are read as 2000 to 2049 from 00 to 49, and as 1950 to 1999 from 50 to 99. A date that isn’t in the calendar, like 31/02/2026, is left as it is.
To keep the date and also have its year or its month in a column of its own, duplicate the column first and reformat the copy.
Once reformatted, a column of ISO dates sorts in date order.