# How to Remove Scientific Notation in Excel (4 Quick Ways)

## What is Scientific Notation?

Scientific notation is a special way of writing very small and very large numbers using a shorthand method.

The following dataset has two columns with Scientific Notation and Without Scientific Notation. We will take the first column numbers and remove the scientific notation. Cell (B5), (B7) contains very large numbers (E+ denotes the large positive numbers) and cell (B6), (B8) contains very small numbers (E- denotes negative small numbers).

### Method 1 – Remove Scientific Notation Using Cell Formatting

STEPS:

• Copy the first column numbers to the next column.
• Selecting the numbers, Right-click on your mouse.
• Select Format Cells. This will open the format cells dialog box.

• From the Number tab, change the category General to Number.
• Set the number of Decimal places toÂ 19 and Press OK.

Now, you can see the number without any scientific notation.

Remember that for decimals with a noticeable number of zeros (0) before a non-zero digit, you have to increase the decimal places; otherwise, the numbers will show zero (0).

### Method 2 – Erase Scientific Notation from Numbers Using Excel Functions

#### 2.1 Use of the TRIM Function

STEPS:Â

• Enter the formula in Cell C5Â and Press ENTER.
`=TRIM(B5)`

• Â Drag the fill handle to all the cells you want to use in this formula.

Now, you can see your desired results.

#### 2.2 Use of CONCATENATE Function

STEPS:

• Enter the following formula in Cell C5Â and Press ENTER.
`=CONCATENATE(B5)`

• Drag the fill handle over to the range you want to remove the scientific notation.

#### 2.3 Use of the UPPER Function

STEPS:

• Enter the following formula in Cell C5:
`=UPPER(B5)`

• Drag the fill handle over to the range you want to apply the formula.

### Method 3 – Delete Scientific Notation by Using Text to Column Feature in Excel

STEPS:

• Copy the data from the scientific notation column and paste the data.
• Select the cells you want to remove scientific notation.

• Go to the Data tab in the ribbon.
• Click on Text to Columns.

• You can see a dialog box. Select Fixed width.
• Click on Next.

• Click Next again in the second step of the wizard.

• Select General to Text from the column data format.
• Press Finish.

### Method 4 – Delete Scientific Notation by Adding an Apostrophe at the Beginning

You can also remove the scientific notation by adding an apostrophe/a single quote (â€˜) before entering the number.

Add an apostrophes to all cells to remove scientific notation.

## Things to Keep in Mind

Excel cannot keep more than 15 digits of the original number, the other digits are changed to zeroes.

<< Go Back to Scientific Notation in Excel | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF