Is it possible to automatically get a degree symbol in a celcius once a type a number. It is possible with currency etc. under format cell and then number but I can't find temperature anywhere. Thanks in advance for the help.
Is it possible to automatically get a degree symbol in a celcius once a type a number. It is possible with currency etc. under format cell and then number but I can't find temperature anywhere. Thanks in advance for the help.
Let's say that in A1 we have 30.123456 this is a little more than 30 degrees. In A2 put =A1/24 and format A2: Format > Cells... > Number > Custom and enter [hh]°mm'ss\" in place of General to see: 30°07'24".
Try this: Select the cells to be impacted. From the Excel main menu: <format><cells><number tab> Category: Custom
- Type: enter the word: General
- then hold down the [alt] key
- type 0176...release the [alt] key
- type a space
- type C
- Click the [OK] button
That will make 21.5 display as: 21.5° C. Or else you can use the character map, copy the symbol. format cells use custom and paste as follows #,##°.
Bookmarks