I want to make a spreadsheet with Google Sheets to compare microprocessor's specifications. One column will show processor speed, another will show program space, another for RAM space and so on.What I'd like is a custom number format that could display values to something along these lines:Processor speed:I enter into a cell:1,000,000,000 which then displays as 1GHz 20,000,000 which then displays as 20Mhz 16,500,000 which then displays as 16.5MHzEEPROM:I enter into a cell:12,000 which then displays as 12kB765 which then displays as 765BHow can I do this? I know some javascript programming, so perhaps I could do it that way. Perhaps there's a built in way of doing it though? I can't even find javascript API which lets me create custom number formatting rules other than the syntax characters that can be used to create a custom number format, as per this help document.I will have one row for each microprocessor, and one column for a specification (e.g. one column for processor speed, one column for 32 bit/ 64 bit). I will want to sort them, so 20,000 should be sorted as being greater than 20, even though 20GHz sorted alphabetically would be less than 20Mhz.I will want to be able to sort the columnsEdit:To clarify, I want the formatted version (e.g. 1GHz) to appear in the same cell as the one I enter the number 1,000,000,000.For example, All of column AB I use for processor speed. In any cell of column AB I enter a number, it will format it into GHz/MHz/kHz/Hz. In other words, say I use column AE for the price of the microprocessor. To set up the formatting, I highlight the whole column AE, then in the menu I go to Format > Number > Currency. Then when I enter 3.45 into any cell in column AE, the number re-formats to 3.45. 
Google Sheets: Format number as Mhz/kHz, or MB, kB etc
conditional formatting;google spreadsheets