Excel Magic Trick #247: Add Leading Zeroes w Formula
Online Courses for microsoft excel :
Course updated 2009-03-20 17:55:58
Instructor : ExcelIsFun
Course Duration : 2:41
Rating : 5.00 / 5
Step by step & Descreption :
See how to add leading zeros to a text string with an array formula. See the functions IF, LEN, MAX and REPT in one array formula.
The LEN function counts how many characters there are in a text string
The MAX function finds the biggest value amongst a list of values
The REPT function repeats a text string a specified number of times
Array Formulas are entered with the key strokes: Ctrl + Shift + Enter.