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.5MHz"
EEPROM: I enter into a cell:
- "12,000" which then displays as "12kB
- "765" which then displays as "765B"
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 columns
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.