Add Description in Dropdown List Excel
Solution 1:
That looks to me like a technique I sometimes use, using custom number formatting to display additional information without introducing messy text to be parsed elsewhere. Eg "£1,234 net profit" or ""72 unique customers".
If you look at the number format for that cell i suspect you will see something like:
0": Net of tax";;0": Gross of tax";@
(the important parts are distinguishing between positive and zero values, it seems negative will not be an option so may be omitted (hence ;; with nothing between them)