How does Excel convert numbers in batches into degrees?

We often in Excel to make some degrees, but in the caret can only make individual degrees, how to batch production degree? Now let's take a look at how to bulk convert numbers to degrees.

Final Effect Diagram:

First, preliminary preparation:

Open the Excel software and now make some numbers in column A, as shown in the figure, we will convert a column number to degrees in column B.

Second, the degree of conversion

Now we move the mouse over the back blank cell, and click Insert--the symbol.

In the Open Symbol dialog box, click the Symbol tab, select (normal text) in font, and select Latin-1 supplement in subset.

Now move the cursor to the "B1" cell, enter "=a1&" and return.

At this point in the B1 appeared "30°", as shown in the picture, the mouse to the "B1" cell in the lower right corner of the black cross, drag the mouse down to fill all the cells, this time in column B is converted to a good degree.

Above is how Excel batch converts the number to the degree method introduction, the operation is very simple, everybody has learned? Hope to be helpful to everyone!