In Excel, numbers are stored in Scientific Notation. The Scientific Notation has a number limit of 15 numbers. Therefore, if your dataset exceeds 15 numbers, Excel automatically converts the number into scientific notation. When a large number is converted to scientific notation, an **e (Euler’s number) **is added to the number. This article will discuss ways of removing the e from your dataset.

**Using the Custom Number Tool**

**A] Using the Home Tab**

Steps to follow:

**1.** Open the Excel application.

**2.** Open the Workbook that contains the dataset with the Euler’s numbers.

**3.** Click or highlight the cells with the e values.

**4.** Click the **Home **tab on the Ribbon, and locate the **Number **section. Click the Dialogue launcher icon.

**5.** In the **Format Cells **dialogue box, click the **number **tab. Click the **Number **button. Set the number of decimals places to **zero**.

Hit the **OK **button.

**B] Using the Right-click feature**

Steps to follow:

**1.** Open the Excel application.

**2.** Open the Workbook that contains the dataset with the Euler’s numbers.

**3.** Click or highlight the cells with the e values.

**4.** Right-click and select the **Format cell **option.

**5.** In the **Format Cells **dialogue box, click the **number **tab. Click the **Number **button. Set the number of decimals places to **zero**.

Hit the **OK **button.

**Using the TRIM Function**

**A] Using Formula bar**

Here are the steps to follow:

**1.** Open the Excel application.

**2.** Open the Workbook that contains the dataset with the Euler’s numbers.

**3.** Click on an empty cell that will hold the results, and then click on the **Formula bar.**

**4.** Type the **Equal sign **followed by the **TRIM **function. That is, **=TRIM (**

**5.** Select the cell with the Euler number. For Example, **=TRIM (A1)**

**6.** Finally, hit the **Enter **key.

**B] Using the Insert Function Tool**

Steps to follow:

**1. **Click on the **Formulas tab **on the screen, and then locate the **Function Library **section.

**2.** Click the **Insert Function **button to open the **Insert Function **dialogue box.

**3.** In the **Search for a Function **section, type **TRIM **and press the **Go **button.

**4.** Select the **TRIM** option in the Select a Function section and then hit the **Ok **button.

**5.** In the **Text **section, click the right button and select the cell containing the Euler’s numbers.

**6.** Finally, click the **OK **button.

**Using the CONCATENATE function**

Steps:

**1.** Open the Excel application.

**2.** Open the Workbook that contains the dataset with the Euler’s numbers.

**3.** Click on an empty cell that will hold the results, and then click on the **Formula bar.**

**4.** Type the **Equal sign **followed by the **CONCATENATE **function. That is, **=CONCATENATE (**

**4.** Select the cell with the Euler number. For Example, **=CONCATENATE (A1)**

**Using the UPPER Function**

Steps:

**1.** Open the Excel application.

**2**. Open the Workbook that contains the dataset with the Euler’s numbers.

**3.** Click on an empty cell that will hold the results, and then click on the **Formula bar.**

**4.** Type the **Equal sign **followed by the **UPPER **function. That is, **=UPPER (**

**5.** Select the cell with the Euler number. For Example, **=UPPER (A1)**