Most valuable professional
  • Hot Topics

Excel Custom scientific notation format not working

I would like to modify the standard scientific notation format so that it shows 2 decimal places to the left and none to the right. So 123 million (123,000,000) would be "12 E+07" rather than "1.2 E+08". Here's an example. The default format is in C. The format I tried is in E. It works perfectly in E4 & E5, but in E6:E9, it has a leading zero. How can I get those to work like the ones above? C/R 3 4 5 6 7 8 9 Thanks

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of February 25, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel