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...
TRS111 Perhaps a custom format can achieve what you need. Create a custom format like in the first picture.
......and apply that format to the numbers that represent temperatures. In the example below, C2 contains the number 10.5 but it is displayed as 10.5 ℃
- 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.
