Convert Text to Numbers
Convert numeric text in selected columns and report skipped cells.
Remove ambiguity from date text by choosing the source convention explicitly. Invalid dates are left unchanged and reported.
Loading workspace…
Preparing the controls for this tool. Your files have not been selected or uploaded.Working with many files? Open batch processing for supported operations. Batch uses its own basic options.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.
Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.
Available source formats are DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD and Excel serial. Outputs use the chosen date text convention. With DD/MM/YYYY input, 31/12/2025 becomes 2025-12-31 when ISO-style output is selected.
The tool does not guess whether 03/04/2025 means 3 April or March 4. Impossible calendar dates and unmatched values remain unchanged. Excel serial conversion uses the 1900 date system and rejects the fictitious serial day 60; confirm sources using the 1904 system separately.
They may not match the selected source format or may be impossible dates. Read the warnings and correct the source values instead of choosing a format at random.
No. The exported worksheet contains values, including normalized date text, rather than the original cell styles or recalculated formulas.
Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.