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.




Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com