Blog Stats
- 2,324,652 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- Filter a list of items from a long long list
- Open an embedded Excel file during a slide show in PowerPoint?
- Insert a text string into a specific position of another text string in #Excel
- Dropdown calendar in Excel
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: May 2016
Extract 6 digits from a string and convert it into date
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
Display single letter Day of week in Excel
Is it achievable? Not by formatting but formula.
Number Stored as Text…
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
Copy customized Ribbon and QAT to another PC
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