Session 2: Friday, 7 March, 11h00 - 12h30
Tel: 086 167 3923 Email: Info@SummitSolutions.co.za
August 20, 2019
Mark - Summit Solutions
We often receive data where the Date Format is incorrect and subsequently does not load as a genuine date. (Remember, a Date is numeric, so should align to the right)
Trying to force it to be Date using the Short Date Format does not work and using Text Formula can be c...
August 7, 2019
It’s always a good idea to store ID Numbers as Text, especially as some can start with a leading zero.
The problem though, is that if you convert cells with large numbers to Text it displays it in Scientific Notation. E.g. 8605065397083 display as 8.60507E+12!
This can b...
Excel Tip - Validating an SA ID Number
July 29, 2020
Excel Tip - Catering for Millennials in D.O.B. from an ID Number
July 15, 2020
Excel Tip - Extracting a Date of Birth from an ID Number
June 30, 2020
Excel Tip - Storing Generation-Z ID Numbers.
June 17, 2020
Excel Tip – Number Formatting Keyboard Shortcuts
June 5, 2020
Excel Tip – Copy & Paste and keep Column Widths
February 26, 2020
Changing Values from Negative to Positive and Visa Versa
February 13, 2020
Excel Tip – The Format of an Inserted Column
January 28, 2020
Excel Tip – Entering the Current Date and Time
January 16, 2020
Excel Tip – Navigating a Workbook with Lots of Worksheets
December 4, 2019
Excel Tip – Using the Format Painter multiple times
November 20, 2019
Excel Tip – Quickest way to move a column!
November 6, 2019
Excel Tip – How to handle Financial Years that are not Calendar Years
October 23, 2019
Excel Tip – What to do with Leap Year Babies!?
October 8, 2019
Excel Tip – Extracting a Birthday from a Date of Birth
September 20, 2019
Excel Tip - How to calculate the number of Working Days between 2 Dates
September 11, 2019
Excel Tip - How to fix incorrect Date formats in a jiffy!
Excel Tip - Prevent Large Numbers from converting to Scientific Notation.