How does Excel convert numbers in batches into degrees?

Source: Internet
Author: User

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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.