I have a Google Spreadsheet and I have a lot of numbers in it. Those numbers are very big ones like
I would like to make the them into
m style, like
And I'd like to ignore the smaller part of the numbers, for example, I need to turn
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?