Shopping Cart

Storing SA ID Numbers

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 Databases it has now become a problem.

For Example: A Generation-Z ID of 0105145027085, when entered in Excel converts to a Number and displays as 105145027085! Excel hijacks the leading zero, just like it does with phone Numbers.

To Fix this we need to start storing our ID numbers as Text, and to do that we either need to prefix each ID Number with an apostrophe (‘) or better still, pre-format your ID Number column as Text.

To become more proficient with the use of numbers, data ranges and databases, check out one of our online Excel courses, with training offered for both beginners to advanced users.

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks

This draw is closed. Keep checking back, for the next draw.