Hi. I'm doing a stock take at work and I want to store resistor values as numbers but have them displayed in resistor convention e.g -
120 is displayed as 120R
12,300 is displayed as 12K3
1,100,000 is displayed as 1M1

I can't seem to get the hang of all these #,## 0's and such, any help would be greatly appreciated. thanks.