a million dollar trick !!!

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.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s