Forum Discussion
Insert Degree Symbol in Average Calculation
I have a list of temperatures that is 364 rows long and have an average calculation at the bottom. I am attempting to find a way to enter, if possible, the degree symbol ASCII 0176 in the line of te...
Riny, I appreciate the reply. I could not get the suggestion put into practice, however. I think the problem I am running into is that there are already conditional formats in these columns and then, on top of that, the average calculation done at the bottom to show average temps is, yet, another calculation. The additions I've tried so far tend to totally wipeout the pre-existing formatting and it doesn't even allow me to utilize the character stroke ALT-0176 to put the degree symbol in. If I do a simple insert, it fouls things up as well. I guess I'll just abandon the effort but really appreciated your help. My best to you. Tom
TRS111 Not sure I follow. The custom format determines how the number is displayed. It is not influenced by conditional formatting (cf). Thus, you should be able to "attach" the Celcius sign to a number and still use cf on it.
Perhaps you can upload a portion of your workbook that has with temperatures and averaging formulae in it, as well as some conditional formats.