How to Abbreviate Large Numbers in Excel (1.2M)
A custom number format can show 1,200,000 as 1.2M, and that is the right answer while the cell stays in Excel. It is the wrong answer the moment the value has to leave: a chart label, a slide, an email or a CSV takes the underlying number and ignores the formatting entirely.
Last updated: October 2026
| Value | → | Shortened |
|---|---|---|
| 1200000 | → | 1.2M |
| 2500 | → | 2.5K |
| 3400000000 | → | 3.4B |
Format or value — which do you need?
- A custom format (
0.0,,"M") keeps the real number in the cell and only changes how it looks. Right for a sheet that stays a sheet, and the arithmetic still works. - A shortened value is text that says 1.2M. Right when the number is going into a label, a slide, a message or another system — anywhere the formatting will not travel with it.
And back again
"2.5K" pasted in from a dashboard or a report is text, and no amount of formatting makes it add up. Expanding it to 2500 is the step before any arithmetic — and it understands the conventions interchangeably, so K, k, m, bn, and the words in full all expand correctly.
The 1-click way (Tellsheet)
Abbreviate Large Numbers
Select the range and run Abbreviate Large Numbers. Choose K/M/B/T, lower-case k/m/bn, or the words in full, and how many decimal places — trailing zeros are dropped, because 1.0M reads worse than 1M in a label. Run it the other way to expand. Anything that is not a number is left exactly where it is and counted.
Frequently asked questions
Why not a custom number format?
Use one if the cell stays in Excel; this is for when the value leaves.
Which suffixes?
K/M/B/T, lower-case k/m/bn, or the words in full.
Can it expand 2.5K back?
Yes, and it understands the other conventions too.
What about lakh and crore?
Use India ↔ International Numbers for those.
Related Excel guides
Short enough for a label
Abbreviate Large Numbers writes the short form as the value — and expands it back when you need the maths.
Get Tellsheet free See pricing