How the Currency & Number Normalizer Works
AnyTool normalizes numbers entirely in the browser. Each line is stripped of currency symbols, ISO codes and stray text, and accounting/percent markers are detected (parentheses or a trailing minus mean negative; a trailing % divides by 100). The decimal separator is then resolved: when both "." and "," appear, the last one is the decimal and the other is grouping; when only one appears, a single separator with one or two trailing digits is treated as the decimal while three trailing digits (or repeated separators) are treated as thousands grouping — and an explicit "dot" or "comma" setting overrides the guess for ambiguous data. Grouping is validated against Western (1,234,567) and Indian (12,34,567) patterns, so malformed input like "1.2.3.4" is rejected rather than silently collapsed. The parsed value is then reformatted with Intl number formatting to US, European, Indian, Swiss or plain style, with configurable decimal places, optional prefix/suffix and minus-or-parentheses negatives. The tool reports the detected convention per row and computes count, sum, mean, min and max, with TXT/CSV export. Nothing is uploaded.
- Runs client-side — financial figures are never uploaded
- Reads US, EU, Indian, Swiss, space-grouped, % and (negatives)
- Auto-detects the decimal separator, with a dot/comma override
- Validates Western & Indian grouping (rejects malformed numbers)
- Reformats with Intl; prefix/suffix, decimals, accounting negatives
- Count, sum, mean, min, max; no CDN, no backend, no row cap signup
