... when using Excel, here's how to format a group of cells to automatically add a degree symbol (°) to the end of a number.
1. Select (highlight) the column(s) and/or row(s) that you want to include.
2. Go to the Format menu and select Cells.
3. On the Number tab, scroll down on the left to Custom.
4. In the right hand 'Type' field, input the number of numeric characters to be included using pound symbols (ex. #### for up to four numbers)
5. Use ALT + 0176 to add the degree symbol to the end (ex. ####°).
6. Click OK.
Note You must use the numeric keypad to type the numbers and not the keyboard. Make sure that the NUM LOCK key is on if your keyboard requires it to type numbers on the numeric keypad.
This will add a degree symbol to the end of all numbers currently in those cells and any future ones added.
Here is an article that may provide additional ideas: http://office.microsoft.com/en-us/help/HA011179441033.aspx
I found this utility that would add new number formatting functionality in Excel including adding a degree symbol: ConnectCode http://www.spreadsheetml.com/numbermanager.html
I hope this helps.