Number Formatter
Clean currency, decimals, percentages and thousand separators.
Convert text that looks numeric — “$1,234.50”, “(500)”, “45%” — into real numbers, then apply a consistent display format across the column. Handles European decimal commas and accounting-style negative parentheses.
- Rating
- 4.8(1.5K)
- Monthly uses
- 184K
- Price
- Free
or drag it here
.xlsx, .xls, .csv · processed locally, never uploaded
Files stay on your device
What it does well
- Strips currency symbols, spaces and thousand separators before parsing
- Accounting negatives in parentheses parsed to real negative numbers
- Rounding with configurable decimals and half-up or banker’s rules
How to use Number Formatter
- 1
Upload the file and select the numeric columns.
- 2
Set the input convention — decimal point or comma, and how negatives are written.
- 3
Choose the output format: plain, currency, percentage or accounting.
- 4
Apply and download.
Watch a walkthrough
Common problems and fixes
Values still show as text after formatting.
They contain a character the parser did not recognise, often a non-breaking space. Run the Data Cleaner first, then re-format.
Large IDs are converted to scientific notation.
Exclude that column and mark it as text — identifiers should not be numbers. The type override is in the column editor.
Frequently asked questions
What people say
Our IT team blocked every other online tool because they upload files. This one does not, so number formatter finally got approved for use on real data.
Small thing, but the error messages actually tell you what to fix. Number Formatter flagged a hidden character that had been breaking my lookups for weeks.
The preview before committing is the part that sold me — I could see exactly what number formatter was going to change before it changed anything.
More clean & format tools
Remove duplicates, trim whitespace, fix inconsistent dates and numbers, split or merge columns, and validate data quality before it reaches your reports.
Browse Clean & Format