How to Stop Excel from giving a number in scientific notation

If you ever enter a very large number into a cell, you'll notice that Microsoft Excel displays it in scientific notation. For example, when you enter the number 1231231231234 in a cell, Excels displays 1.23123E+12. No matter how large you make the cell width, Excel still displays a number larger than 12 characters in scientific notation.

To display the number in a format other than scientific notation, you need to reformat the cell(s). Here's how:

We have two methods to get rid of this issue.

Method 1

Concate the scientific notation with a single quote('), you will get the proper number.

1.11E+19

'11111111111111100000

But we have a issue still exists if it cross 20, here is an example.

1.11E+20

'1.11111111111111E+20

Disadvantage: So you cannot use method1 if it cross 20.

Method 2

Step1:  Select the scientific notation , Go to format cell, select Text

Step2:  Select the scientific notation which you made as text, Go to format cell make it as number, remove the decimal numbers.

1.00E+20	1.00E+20
1.00E+27	1.00E+27
1.00E+28	1.00E+28
1.00E+30	1.00E+30
1.00E+34	1.00E+34
1.00E+38	1.00E+38
1.20E+19	1.20E+19
1.20E+23	1.20E+23
1.20E+26	1.20E+26
1.20E+42	1.20E+42
2.70E+124	2.70E+124
5.03E+11	5.03E+11

After applying formats

1.00E+20	100000000000000000000
1.00E+27	1000000000000000000000000000
1.00E+28	10000000000000000000000000000
1.00E+30	1000000000000000000000000000000
1.00E+34	10000000000000000000000000000000000
1.00E+38	100000000000000000000000000000000000000
1.20E+19	12000000000000000000
1.20E+23	120000000000000000000000
1.20E+26	120000000000000000000000000
1.20E+42	1200000000000000000000000000000000000000000
2.70E+124	27000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
5.03E+11	503006036010

Disadvantage: it will work for more than 20, but it cannot handle leading zeros, leading zeros will be trimed off.