Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging
PROBLEM: retaining a leading 0 (zero) when entering Post Codes. When you enter a post code that has a leading 0 (zero), e.g….
Excel – How do I merge cells within a range that is formatted as a Table?
Question: When I use Excel “Format as Table” to format a range, the Merge & Center button is greyed out and becomes…
Excel – Why does the 0 (zero) disappear?
PROBLEM: why does the 0 (zero) disappear in Excel? How do I stop the 0 from disappearing? SOLUTION: learn how to stop zeros…
How to create a list of Working Days – Excel WORKDAY function
This post has been updated and added to by Sharyn, November 2020. Need a list of weekdays or workdays only? Let’s look…