Monthly Archives: May 2016

Extract 6 digits from a string and convert it into date

Posted on May 28, 2016 by MF

Got a question about how to extract the date of birthday (DOB) portion from an ID number like 63102400965, where the first 6 digits represent the DOB, so that we could use the date for other calculation.  In this example the DOB … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Display single letter Day of week in Excel

Posted on May 21, 2016 by MF

Is it achievable?  Not by formatting but formula.

Rate this:

Posted in Format, Formula | Tagged , , , | Leave a comment

Number Stored as Text…

Posted on May 14, 2016 by MF

It is something basic and commonly seen.  Nonetheless,  it is really important to understand the different behaviors between a number, and a number stored as text, especially if you want to move forward to write effective formula.  This post is intended … Continue reading →

Rate this:

Posted in Excel Basic, Formula | Tagged , , | 5 Comments

Copy customized Ribbon and QAT to another PC

Posted on May 7, 2016 by MF

Customized Ribbon and QAT is very common.  I believe all serious Excel users will have their own customized Ribbon and QAT according to their own working habits. I rarely share my customization with others and I am not going to … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment