Excel tips

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)

It’s always a good idea to store ID Numbers as Text, especially as some can start with a leading zero. In this article we focus on displaying I.D numbers correctly

It’s pretty well known that the first 6 digits of your South African ID Number is your Date of Birth. Un-beknown to many though, the SA ID Number has a

As more and more Millennials creep into our Databases it’s important that we beef up our Formula and learn about extracting D.O.B’s from ID’s. With just a 2-digit year, the

A client of ours once accidentally deleted all their respective Client Birthdays. They were incredibly relieved when they were introduced to the following Formula: =DATE(LEFT(A2,2),MID(A2,3,2),MID(A2,5,2)) Simply copy and paste the

When we capture a South African ID Number, Excel recognizes it as numeric and displays it to the right of the cell. Up until recently this has not been an