Excel: Remove E+ From Numbers

Have you ever noticed that when you type a really large number into Excel it’s sometimes displayed with an E+ and a number at the end:

It’s known as scientific notation and for most people it’s annoying.

There are several ways to change this so that the cell displays the number with all the digits and in this video I’m going to show you 5 ways to do so.

1. Type an apostrophe at the beginning of the cell entry
2. Format the cells as Text
3. Format the cells as Number
4. Text to Columns
5. Use Power Query

Type an apostrophe at the beginning of the cell entry

Format the cells as Text

Format the cells as Number

Text to Columns

Power Query