Excel's TEXT Formula
Don't miss Excel's versatile TEXT formula, which can help you quickly format columns of data. The TEXT formula begins with a cell reference or value, and then ends with a code. This version . . .
. . . will convert the value in cell A2 into a date format.
When written this way:
. . . the formula can easily convert a column of numbers of varying lengths into a standard format with a consistent number of digits.