Number Formatting Playground
See how numbers, prices and percentages look in different languages and regions. Compare formats without changing the values.
How do I format numbers for different countries?
Enter numbers, one per line. Choose a language and region, then a number, price, percentage or unit style. Compare the results and copy or download them. This changes how values look; it does not convert currencies or measurement units.
One value. Many ways to read it.
Compare presentation without changing the original numbers. Nothing is uploaded.
Rounding, grouping and signs
halfExpand rounds ties away from zero; halfEven rounds ties to the even digit. ceil and floor round toward positive and negative infinity. trunc rounds toward zero; expand rounds away from zero. Increments use the last decimal place: 5 with two fixed places rounds to 0.05. Increment rounding needs equal minimum and maximum decimal places.
Three simple steps
How to use Number Formatting Playground
Choose your input number format, then select a display locale and style.
Adjust digits, rounding and signs. Review original values and any invalid cells.
Copy the preview or export the complete report. Keep a project backup before leaving.
Common questions
Good to know
Understand the result.
Keep the original.
Is this tool free, and are my files uploaded?
This tool is free with no account required. The work happens in your browser. Your input and files are not sent to a processing server.
What are the limits and details?
Display formatting only; no currency or unit conversion. Decimal strings retain their exact input digits before display rounding; JSON numbers may already have floating-point rounding, so quote precise values. Up to 200 input digits, 300 characters per numeric cell and exponents/magnitudes between −300 and 300. Canonical input uses a decimal point without grouping; localized input uses the selected locale’s digits and decimal/thousands separators. Currency symbols, percent signs and accounting parentheses are not accepted as numeric input. Decimal-place precision supports 0–20 places; significant precision supports 1–21 digits. Output depends on the browser’s locale data and requires exact-string and rounding-option support. Report imports support 5,000 rows, 30 columns and 1.5 million characters; formatted results support 6 million characters. Empty values remain empty and invalid values remain unchanged, with explicit export acknowledgement. CSV prefixes formula-like text; optional spreadsheet-text mode prefixes every nonempty data cell. CSV loses JSON types and null/empty distinctions; retain the JSON report or project backup. Data stays in this browser session; download a project to resume later.