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:
- Microsoft Excel