I want to see big numbers in same power of scientific notation in microsoft excel
for example, I want to see these numbers in excel cells
1.23E+7 1.45E+10 1.36E+12
as below:
1.23E+7 1453.11E+7 136445.11E+7
(all with E+7 power)
I want to see big numbers in same power of scientific notation in microsoft excel for example, I want to see these numbers in excel cells 1.23E+7 1.45E+10 1.36E+12 as below: 1.23E+7 1453.11E+7 136445.11E+7 (all with E+7 power) 


To my knowledge you cannot fix the power using the default formatting (though I'm happy to learn I'm wrong). What you can do instead: use a formula next to it to convert it to your format: =TEXT(INT(A1/10^5)/10^2;"0.00")&"E+7" 


No, not in Excel and still retaining it as a numeric value. But, if you are willing to accept "E+n" where n is a multiple of 3 you can use custom number formats such as: #,##0.00,"E+3" #,##0.00,,"E+6" #,##0.00,,,"E+9" Each comma appearing after the decimal point shows the output divided by 1000. Using custom number formats has the advantage of keeping the real numeric values unmodified and suitable for further calculations. 

