SUBSCRIBE FOR FREE EXCEL TIPS

August 12, 2020

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...

Its 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 few other Personal Details hidden within its 13 digits!

This is the breakdown {YYMMDD}{G}{SSS}{C}{A}{Z}

YYMMDD: Date of...

As more and more Millennials creep into our Databases, it’s important that we beef up our Formula that extracts a Date of Birth from an ID Number to accommodate them.

With just a 2-digit year, the Excel Date function assumes the 1900s. As a result, the ID Number of some...

Have you ever had to extract a Date of Birth from an ID Number?

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))

Si...

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 issue, but as Generation-Z, or more specifically those born between 2000 and 2009, start creeping into our Databas...

Please reload

Please reload

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions