Nice spreadsheet! I also like the raw numbers more so I played around with formatting.
My result is now this:
Just created a custom number format:
[<950]0"";[<999500]0,“K”;0,,“M”
Or with decimals for high numbers but then the columns need to be a bit wider:
[<950]0"";[<999500]0.0,“K”;0.0,,“M”
(replace double quotes with normal ones due to forum formatting)
and then applied the formatting like it is in the raw number sheet