Mursalin Ibne Salehin
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.
Download Practice Book
Download the practice book here.
4 Quick Methods to Type Diameter Symbol in Excel
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.
- Secondly, go to the Insert tab and select Symbol. It will open the Symbol dialog box.
- After that, select ASCII (decimal) in the ‘from’ box.
- Then, select the diameter symbol and click on Insert.
- Finally, you will see the diameter symbol in Cell C5.
Read More: How to Add Symbol Before a Number in Excel (3 Ways)
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. Pay attention to the steps below for more.
STEPS:
- In the beginning, select the cell where you want to type the diameter symbol. We have selected Cell C5 here.
- 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.
Read More: Excel Formula Symbols Cheat Sheet (13 Cool Tips)
Similar Readings
- How to Type Minus Sign in Excel Without Formula (6 Simple Methods)
- Put 0 in Excel in Front of Numbers (5 Handy Methods)
- How to Add Currency Symbol in Excel (6 Ways)
- Insert Tick Mark in Excel (7 Useful Ways)
- How to Type Delta Symbol in Excel (8 Effective Ways)
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. Let’s observe the steps below to know the technique.
STEPS:
- First of all, select Cell C5 and type the formula:
=CHAR(0216)
- After that, press Enter to see the diameter symbol.
Read More: How to Insert Symbol in Excel Header (4 Ideal Methods)
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. It is also another simple process. So, without further ado, let’s follow the steps below.
STEPS:
- Firstly, go to the Windows Search Bar and type Character Map.
- Click on the Character Map app to open it.
- In the second step, check the Advanced view in the Character Map dialog box.
- Thirdly, type ‘o with’ in the Search for box.
- After that, click on Search.
- Now, double–click on the diameter symbol and click on Copy.
- In the end, select Cell C5 and press Ctrl + V to paste the diameter symbol.
Read More: How to Insert Symbol in Excel Footer (3 Effective Ways)
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
- Insert Degree Symbol in Excel (6 Suitable Methods)
- How to Type Math Symbols in Excel (3 Easy Methods)
- Put Equal Sign in Excel without Formula (4 Easy Ways)
- How to Put a Plus Sign in Excel without Formula (3 Easy Methods)
- Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)
- How to insert square root symbol in Excel (7 easy ways)
- Insert Less Than or Equal to Symbol in Excel (5 Quick Methods)
