How to Type Diameter Symbol in Excel (4 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn to type the diameter symbol in Excel. The diameter symbol [] looks like an O with a slash. It is also known as slashed O or O with stroke. In Excel, we can’t type the diameter symbol directly from the keyboard. Today, we will discuss 4 methods. These methods are easy and quick to apply. So, without further delay, let’s jump to the discussion.


How to Type Diameter Symbol in Excel: 4 Quick Methods

1. Use Insert Tab to Type Diameter Symbol in Excel

In the first method, we will use the Insert tab to type the diameter symbol. Excel has some built-in symbols. From that, we can bring the diameter symbol to our Excel sheet. Follow the steps below to know the whole procedure.

STEPS:

  • In the first place, select cell C5.

Use Insert Tab to Type Diameter Symbol in Excel

  • Go to the Insert tab and select Symbol. It will open the Symbol dialog box.

Use Insert Tab to Type Diameter Symbol in Excel

  • After that, select ASCII (decimal) in the from box.
  • Then, select the diameter symbol and click on Insert.

Use Insert Tab to Type Diameter Symbol in Excel

  • Finally, you will see the diameter symbol in cell C5.

Use Insert Tab to Type Diameter Symbol in Excel

Read More: How to Type Math Symbols in Excel


2. Type Diameter Symbol in Excel Using Alt Key

Another way to type the diameter symbol is to use the Alt key and Alt code of the keyboard. Every symbol in Windows holds a specific Alt code. We can use this code to get the essential symbols.

STEPS:

  • In the beginning, we selected cell C5.

Type Diameter Symbol in Excel Using Alt Key

  • After that, turn on the Num Lock key on the keyboard.
  • Now, press and hold the Alt key.
  • Press 0216 from the keyboard while holding the Alt key. It will not work if you use the number keys at the top of the keyboard.
  • In the end, release the Alt key and you will see the diameter symbol in the desired cell.

Type Diameter Symbol in Excel Using Alt Key

Note:
For Mac, press Option + Shift + O on the keyboard to type the diameter.

Read More: How to Insert Degree Symbol in Excel


3. Insert Excel CHAR Function to Type Diameter Symbol

We can also use the CHAR function to type the diameter symbol in Excel. The CHAR function gets the symbol specified by the code number. To type any symbol with the CHAR function, you must know the Alt code. For the diameter symbol, the Alt code is 0216.

STEPS:

  • Select cell C5 and type the formula.
=CHAR(0216)

Insert Excel CHAR Function to Type Diameter Symbol

  • After that, press Enter to see the diameter symbol.

Insert Excel CHAR Function to Type Diameter Symbol

Read More: How to Add Symbol Before a Number in Excel


4. Copy Diameter Symbol from Character Map to Type in Excel

In the last method, we will copy the diameter symbol from the character map and paste it into our Excel sheet.

STEPS:

  • Firstly, go to the Windows Search Bar and type Character Map.
  • Click on the Character Map app to open it.

Copy Diameter Symbol from Character Map to Type in Excel

  • Then check the Advanced view in the Character Map dialog box.

  • Type o with in the Search for box.
  • After that, click on Search.

  • Now, double-click on the diameter symbol and click on Copy.

  • Select cell C5 and press Ctrl + V to paste the diameter symbol.

Note:
You can also copy the diameter symbol from the internet and paste it into an Excel sheet.

Download Practice Book

Download the practice book here.


Conclusion

In this article, we have demonstrated 4 quick methods to type the diameter symbol in Excel. These methods are simple and easy to understand. I hope these methods will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles


<< Go Back to Mathematical Symbols in Excel | Insert Symbol in Excel | Excel Symbols | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo