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

Written by Mursalin Ibne Salehin

Last updated: May 14, 2024

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.

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

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.

Download the Practice Book

Type Diameter Symbol.xlsx

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!

SaveSavedRemoved 0

Tags: Mathematical Symbols in Excel

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

2 Comments

Reply
Sleep Lean Oct 31, 2025 at 8:15 AM

Great tips! I always struggled to insert the diameter symbol in Excel, but your step-by-step methods made it so easy. Thanks for sharing these shortcuts!
- Reply
  Shamima Sultana Nov 2, 2025 at 12:02 PM
  
  Hello,
  
  Thanks so much for your kind words! I’m really glad the guide helped you learn an easier way to insert the diameter symbol in Excel. It’s a small detail, but it makes a big difference when formatting data or engineering sheets. Appreciate you taking the time to comment!
  
  Regards,
  ExcelDemy

Leave a reply Cancel reply

Submit Excel Problem