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

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.

Use Insert Tab to Type Diameter Symbol in Excel

  • Secondly, 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 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.

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: Excel Formula Symbols Cheat Sheet (13 Cool Tips)


Similar Readings


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)

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 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.

Copy Diameter Symbol from Character Map to Type in Excel

  • 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, doubleclick on the diameter symbol and click on Copy.

  • In the end, 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.

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

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer as well as an electrical and electronics engineer. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo