Approximate Symbol in Excel (The Ultimate Guide for 2025)
In this article, we will show you how to make an approximate symbol in Excel. Simply follow the steps below.
Adding an Approximate Symbol in Excel
To use the approximate symbol in Excel, we will use a dataset that includes project names in Column A, estimated expenses in Column B, and actual expenses in Column C. Follow the steps below.
1. Click on the Cell Where You Want to Insert the Approximate Symbol
Begin by selecting the cell in your Excel sheet where the approximate symbol should appear. In our example, we will click on the cell directly before the “$20,000” in the ‘Estimated Expense’ column for the “Market Research” project.
2. Navigate to the ‘Insert’ Tab and Select ‘Symbol’
To access the symbol menu, navigate to the ‘Insert’ tab located at the top of your Excel menu bar. Here, you’ll find the ‘Symbol’ option; click on it. This action opens the Symbol dialog box where various symbols are available.
3. Locate the Approximate Symbol Using Its Character Code
In the Symbol dialog box, find the approximate symbol (≈) quickly by typing 2248 in the ‘Character code’ field. Ensure that the ‘from’ dropdown menu is set to ‘Unicode (hex)‘ to correctly interpret the code. This specific code is the standard Unicode point for the approximate symbol.
4. Insert the Approximate Symbol by Selecting It and Clicking ‘Insert’
After locating the approximate symbol in the dialog box, click on it to select it. Then, press the ‘Insert’ button. This action will place the symbol in the Excel sheet at the position of your selected cell.
We will now see the symbol appear before the estimated expense value.
We hope that you now have a better understanding of making an approximate symbol in Excel. If you enjoyed this article, you might also like our articles on how to insert an ohm symbol in Excel and how to add a pound symbol in Excel.
