Number Formatter
Formula
Format with locale separators
Enter any number to see it formatted with comma separators and in abbreviated notation (K for thousands, M for millions).
How to use
- Type the value you want to shorten in the Number field.
- Choose Thousands, Millions, or Billions in Format As.
- Read the abbreviated value and the full number below.
Example
Enter 1,234,567 and choose Millions. Dividing by 1,000,000 gives 1.23, so the number is written as 1.23M.
Frequently Asked Questions
What is 1,234,567 in millions?
1,234,567 = 1.23M.
How do I read a number written as 2.5B?
The B stands for billion, so 2.5B means 2.5 billion, or 2,500,000,000 written in full. To reverse the abbreviation, multiply the number before the letter by the unit it represents: 2.5 x 1,000,000,000. This shorthand is common in financial reports and headlines where exact digits would be hard to scan.
Why does my abbreviated number lose some precision?
Rounding to one or two decimal places drops the smaller digits, so 1,234,567 shown as 1.23M hides the exact 234,567 portion. For headlines and dashboards this is fine because readers care about scale, not the last few dollars. When precision matters, such as accounting or invoices, use the full comma-separated number shown below the abbreviation.