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

## Keyboard Shortcut to Insert Approximate Symbol in Excel

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

ALT + 247

- Ensure that the Num Lock on your keyboard is on.
- Press and hold down the ALT key.
- Type 247 on the numeric keypad (while holding the ALT key).
- 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:

- Click on the cell where you want to insert the symbol.
- Click the Insert tab on the Excel ribbon.

- Click on the Symbol button.

- In the Symbol dialog box, select the ‘Mathematical Operator’ subset from the drop-down.

- Locate the approximate symbol (≈) by scrolling through the symbol list

- Select the symbol and click on the Insert button.

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

Description | Details |
---|---|

Name of Symbol | Approximate Symbol |

Symbol Text | ≈ |

Shortcut for Windows | Alt + 247 |

Shortcut for Mac | Use the Symbol Dialog Box |

Inserting using Symbol Dialog Box | Find ≈ in Symbol dialog box under Mathematical Operators |

Inserting using Formula | =UNICHAR(8776) |

**Other Excel articles you may also like:**