Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to apply degree symbol to weather forecast figure using a modifier key called AltGr. Let’s get started
In the caption below, we have a list of City/States in Nigeria with their respective weather forecast. What we want to do is basically to display the numbers in degree Celsius. Note, the data is stored in Excel Table.
The first thing we will do is select all the number and press CTRL + 1 to open the Format Cells dialogue box
In the Format Cells dialogue box, click on Custom
Clear the General
Execute #,##0 Then hold down the AltGr key on the keyboard and type 0176C
From the Sample of the caption above, we can see that the degree Celsius symbol has been added
Click OK
From the caption above, we can see that the numbers are displayed in degree Celsius
Now, let add the City of Abuja in row 20 with degree Celsius of 33
We can see that the Custom formatting extended to row 20