# How to Insert Approximate Symbol in Excel?

The approximate symbol (≈) is used to indicate that a number is approximately equal to another number but not exactly the same.

It is commonly used in mathematics, science, and engineering to denote a close estimate or rounding of a precise value.

In this article, I will show you some simple ways to insert an Approximate symbol (also called the Almost Equal To symbol) in Excel

Insert Approximate Symbol in Excel

## Keyboard Shortcut to Insert Approximate Symbol in Excel

Below are the keyboard shortcuts to insert Approximate symbol in Excel:

ALT + 247
1. Ensure that the Num Lock on your keyboard is on.
2. Press and hold down the ALT key.
3. Type 247 on the numeric keypad (while holding the ALT key).
4. Release the ALT key to insert the approximate symbol.

Excel on Mac does not have a direct keyboard shortcut for the approximate (almost equal to) symbol in Excel. The symbol can be inserted using the Symbol dialog box.

## Inserting Approximate using the Symbol Dialog Box

To insert the approximate symbol in Excel using the Symbol Dialog Box, follow these steps:

1. Click on the cell where you want to insert the symbol.
2. Click the Insert tab on the Excel ribbon.
1. Click on the Symbol button.
1. In the Symbol dialog box, select the ‘Mathematical Operator’ subset from the drop-down.
1. Locate the approximate symbol (≈) by scrolling through the symbol list
1. Select the symbol and click on the Insert button.
1. Close the dialog box after the symbol is inserted.

## Inserting Approximate Symbol using Formula

Below is the formula you can use to get the approximate (almost equal to) symbol in a cell in Excel:

=UNICHAR(8776)

## Copy and Paste the Approximate Symbol into Excel

Another easy way to insert the approximate symbol is to copy it from a web page or any other document and then paste it into Excel. Here is the symbol for you to copy:

Below is a table that summarizes all the methods to insert the Approximate symbol in Excel:

Other Excel articles you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.