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

Method 1 – Use the Insert Tab to Type a Diameter Symbol in Excel

Steps:

• Select cell C5.

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

• Select ASCII (decimal) in the fromÂ box.
• Select the diameter symbol and click on Insert.

• You will get the diameter symbol in cell C5.

Read More: How to Type Math Symbols in Excel

Method 2 – Type the Diameter Symbol in Excel Using the Alt Code

Steps:

• Select cell C5.

• Turn on the Num Lock key on the keyboard.
• Type 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.
• Release the Alt key, and you will see the diameter symbol in the desired cell.

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

Read More: How to Insert Degree Symbol in Excel

Method 3 – Insert the Excel CHAR Function to Type a Diameter Symbol

Steps:

• Select cell C5 and use this formula:
`=CHAR(0216)`

• Press Enter to get the diameter symbol.

Method 4 – Copy the Diameter Symbol from the Character Map

Steps:

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

• Check Advanced view in the Character Map dialog box.

• Type o with in the Search forÂ box.
• Click on Search.

• Double-click on the diameter symbol and click on Copy.

• Select the 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.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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

Advanced Excel Exercises with Solutions PDF