I have a question about number formatting in EXCEL. I would like to display number in SCIENTIFIC format such that the exponent increments in units of 3. Hence, by order-of-magnitude increments, numbers would appear as: 1, 10, 100, 1K, 10K, 100K, 1M...
Solved by M. U. in 18 mins