Search

# Insert Diameter Symbol (Dia) in Excel

If you work with data related to engineering, manufacturing, or designing, you may have a need to use the diameter symbol in Excel.

The diameter symbol (Ã˜) is also referred to as the dia symbol, slashed circle, slashed O, or O with stroke symbol. It is written as âŒ€20m, meaning the diameter is 20 meters.

In this article, I will show you some easy ways to insert the diameter symbol in Excel.

How to Insert Diameter Symbol in Excel

## Insert Diameter Symbol (Dia) in Excel

Below is a table covering an overview of the diameter symbol (with detailed methods to insert in Excel as separate sections).

### Copy and Paste the Diameter Symbol into Excel

The easiest way to get the diameter symbol in Excel is to copy it from somewhere and paste it.

Below is the symbol you can copy and paste into your Excel cell.

`Capital Diameter symbol - Ã˜`
`Small Diameter Symbol - Ã¸`

Copy these symbols using Control + C, then go to any cell in Excel and use Control + V to paste it.

### Keyboard Shortcut to Insert the Diameter Symbol in Excel

You can use the below shortcuts to insert the Diameter symbol in Excel:

Shortcut for Capital Diameter symbol

`ALT + 0216`

Shortcut for Small Diameter symbol

`ALT + 0248`

To use this shortcut to get the diameter symbol, use the below steps (for the capital Diameter symbol):

1. Select the cell in which you want to get the diameter symbol
2. Hold the ALT key
3. While holding the ALT key, press the 0, 2, 1, and 6 keys one after the other.
4. Release the ALT key.

As soon as you release the ALT key, you will have the capital diameter symbol in the cell.

This shortcut only works with a numeric keypad. Also, you need to have the Num Lock on your keyboard.

Pro Tip: To get the diameter symbol in MS Word, enter 2300, hold the ALT key, and press the X key. This shortcut also works in MS Outlook but not in PowerPoint.

### Formula to Get the Diameter Symbol

Below is the formula that would return the diameter symbol as the result:

Capital Diameter Symbol formula:

`=CHAR(216)`

Small Diameter Symbol formula:

`=CHAR(248)`

Once the diameter symbol is in the cell, you can remove the formula to get the static symbol character.

`Also read: Insert Average (Mean) Symbol in Excel`

### Insert Diameter Symbol Using the Symbol Dialog Box

You can also use the built-in Symbol dialog box to get the diameter symbol in Excel.

Here are the steps to do this:

1. Select the cell in which you want to insert the diameter symbol.
2. Click the Insert tab in the ribbon.
1. Click on the Symbol icon. This will open the Symbol dialog box.
1. Select ‘Latin-1 Supplement’ from the Subset dropdown.
1. Locate the diameter symbol and double-click on it (or select and then click on the Insert button)

This will insert one diameter symbol in the cell.

You can also use the shortcut ALT + N + U to open the Symbol dialog box.

Pro Tip: If you don’t want to spend time locating the diameter symbol, enter 00D8 in the Character code field in the Symbol dialog box. This will instantly take you to the symbol.

`Also read: Insert Approximate Symbol in Excel`

### Using the Character Map

You can also use the character map option in Windows to find and insert the diameter symbol in Excel.

Below are the steps to do this:

1. Search for Character Map in the Windows search bar.
2. Click on the Character Map App. This will open the Character Map dialog box.
1. Click on the Advanced View option. This will show some additional options in the Character Map dialog box.
1. In the Search field, enter the word ‘Stroke’ and hit enter.
1. Locate and double-click on the diameter symbol (called O with Stroke).
1. Click on the Copy button. This will copy the symbol to the clipboard.
1. Paste in a cell in Excel (or where you want it).

Note that this method is independent of Excel. You can use it to get the diameter symbol anywhere in Windows (including other MS Office apps such as Microsoft Word, PowerPoint, Outlook, etc).

In this article, I have covered some easy ways you can use to get the diameter symbol (aka dia, slashed circle, slashed O, or O with stroke) in Excel.

I hope you found this article useful.

Let me know your thoughts in the comments section below. Also, if you know of any other way to do this, do let me know.

Other articles you may also like:

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster