Excel has some pretty neat formatting features. One thing I like is the “custom number formatting,” wherein you can append custom text to a number.
For example, let’s say I have a column of voltages:
To do this, I would specify the following under “custom number formatting”:
Pretty straight forward. Notice that everything (including V) has the same (default) font.
But what if I want the units to be a different font?
For example, lets say I want to make a column of resistance values (units = ohms), such as
2.14 [omega symbol]
5.12 [omega symbol]
5.63 [omega symbol]
I would like the numbers to be in the default font (Arial or whatever), but I would like to append an upper-case Omega symbol (in Symbol font) to the end.
Is it possible to do this using the “custom number formatting” feature?