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 . . .
=TEXT(A2,"mm/dd/yy")
. . . will convert the value in cell A2 into a date format.
When written this way:
=TEXT(A3,"000000000")
. . . the formula can easily convert a column of numbers of varying lengths into a standard format with a consistent number of digits.
