To get the degree sign, hold down the ALT key and enter 0186 on the
numeric keypad (to the right of the keys, NOT the numbers above the
letters).

Hmm! I posted the same message as you did, but I instructed the OP to use
Alt+0176 instead of Alt+0186. They both look like degree symbols to me, but
one seems to display the circle a little higher up than the other. Do you
know what (beside the height thing) is the difference between these two
symbols? Is one of them a degree sign and the other a something else (and if
a something else, what)?

--
Rick (MVP - Excel)