add-commas
Adding commas to numbers inserts thousands separators β 1000 β 1,000 β making large numbers readable. Different locales use different conventions: US/UK use commas (1,000.50), most of Europe uses dots and commas swapped (1.000,50), India groups in 2-2-3 (10,00,000 not 1,000,000), Switzerland uses apostrophes (1'000.50). The ZTools Add Commas tool formats single numbers or whole text blocks (replacing every numeric run), supports per-locale separators, and works with negatives, decimals, and scientific notation.
Use casesβ
Format invoice / report numbers for readabilityβ
$1234567 reads as gibberish; $1,234,567 is instantly clear. Format before printing.
Localise numbers for international audiencesβ
Same dataset shipped to US (1,000.50) and Germany (1.000,50). One pass each β no formatting bugs in spreadsheet exports.
Clean up scraped / CSV dataβ
Web-scraped tables have unformatted numbers. Add commas across the column for human readability.
Format Indian-system numbers correctlyβ
10 lakh = 10,00,000 in Indian convention; 1,000,000 in international. Tool handles both.
How it worksβ
- Paste number(s) or text β Single value or a paragraph with embedded numbers.
- Pick locale β US/UK (1,000.50), EU (1.000,50), CH (1'000.50), Indian (10,00,000), or custom (pick your own thousands and decimal characters).
- Configure decimals β Show as-is, round to N decimals, or pad to N decimals.
- Format β Tool walks the input, formats each numeric run, leaves non-numeric text unchanged.
Examplesβ
Input: 1234567 (US)
Output: 1,234,567.
Input: Same number, EU
Output: 1.234.567 (dot separator).
Input: Same, Indian
Output: 12,34,567 (groups of 2-2-3 from right).
Input: "My salary is 7500 dollars and tax is 2250 dollars"
Output: "My salary is 7,500 dollars and tax is 2,250 dollars" β embedded numbers formatted, prose preserved.
Frequently asked questionsβ
How does Indian numbering differ?
Indian convention groups from the right: last three digits, then twos. So 10,00,000 (10 lakh) not 1,000,000. Common in Indian English / Hindi business writing.
What if my decimal separator is the same as thousands?
Some niche locales use the same character. Tool warns and asks you to confirm β formatting becomes ambiguous.
Negative numbers?
Sign placed before the number: β1,234,567. Some locales use parentheses (1,234,567) β toggle "accounting style".
Scientific notation?
1.5e6 stays as 1.5e6 β formatting digit groups inside scientific notation rarely makes sense. Toggle "expand sci notation" if you want 1500000 β 1,500,000.
Privacy?
All in browser.
Tipsβ
- For international reports, format per locale where the report will be read β not the writer's locale.
- For accounting, use 2 decimal places consistently β irregular decimals look unprofessional in financial reports.
- For Indian audiences, "10 lakh" beats "1 million" for relatability β use Indian numbering when the audience is Indian.
- When working with code, the decimal separator stays as a dot regardless of locale β formatting is for display only.
Try it nowβ
The full add-commas runs in your browser at https://ztools.zaions.com/add-commas β no signup, no upload, no data leaves your device.
Last updated: 2026-05-06 Β· Author: Ahsan Mahmood Β· Edit this page on GitHub