need help on special formatting for cell values

Hi
I'm building a crude parts storage database for a university storeroom, and I'm wondering if it's possible to do some fancy formatting in cells that truncates numbers visually and places a multiplier after the number, for example, turning 38300 Ω into 38.3 kΩ or 2000000 Ω into 2 MΩ, but leaving 470 Ω as is?
I only need it to place no, k, or M multipliers, those are the only multipliers the set will need.
I've included an excel sheet with what I've already figured out (placing the Ω at the end, I'm still learning excel).


Thanks in advance!
Freya


ps: I know excel is not a database tool, but for my purposes it works perfectly for what we needed immediately

Thank you so much!
I had landed on that very page previously and must have glossed over the conditional formatting paragraph -_-'
the format you provided works fantastically, thanks again!

Freya