Monthly Archives: March 2015

100th Post

Posted on March 28, 2015 by MF

Time really flies. This is the 100th post on wmfexcel. I would like to take this opportunity to thank you very much for visiting my blog. Personally I have learnt a lot in the process.  I hope you learn something … Continue reading →

Rate this:

Posted in General | 2 Comments

Show number in thousand (k) or in million (M) by using custom format

Posted on March 14, 2015 by MF

The custom format to show number in thousand or in million is simple: #,##0,“k” #,##0,,“M” The “k” or “M” is optional, depend on whether you want to show it in the header or in the figure itself. The trick is … Continue reading →

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 12 Comments

Delete every thing behind the insertion point – Ctrl Delete

Posted on March 7, 2015 by MF

The shortest post ever! 🙂

Rate this:

Posted in Excel Tips | Tagged | 3 Comments