I have a Google Spreadsheet and I have a lot of numbers in it. Those numbers are very big ones like 2,000,000 or 15,000,000,000

I would like to make the them into k or m style, like 2m or 2000k or 15000m.

And I'd like to ignore the smaller part of the numbers, for example, I need to turn 2,153,278 into 2.15m or 2153k.

I checked the official topic Format numbers in a spreadsheet. I tried a lot of ways but I still don't get the rules. Is it even possible to do that?


1 Answer 1


, represents a thousand.

Custom number formatting:





  • Awesome! Thanks very much! Have two questions: Why do we need an extra ` \ ` before the M? Another question, what if I want to add a , into the number, for example, to turn 2150k into 2,150k? Commented Feb 23, 2018 at 14:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.