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:
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:
|Name of Symbol
|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
Other Excel articles you may also like: