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.