Weather Forecast: How to Apply Degree Symbol using AltGr Key

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


Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *