In a financial model or sales analysis or any other excel worksheet we often need to convert figures in millions. Common methods used are to divide by a million or 10^6, multiply by 10^-6…
Today I learnt a new trick is to multiply by “1%%%” i.e. 1 followed by 3 times % sign. 1 time % gives you an effect of divide by 100, therefore 3 times % gives you divide by a million effect.
another cool trick is to use format cells -> custom->0.00,, i.e 0.00 followed by comma twice. 0.00 for two decimal place two commas for million
however the number will remain in their original format but they will only be displayed in million format.