# How to remove e- in Excel

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) 