Microsoft Office Tutorials and References
In Depth Information
Using Other Functions
TEXT and VALUE
The TEXT function converts a number into
equivalent text. The syntax is =TEXT(Number,
“Format”). The Number argument is pretty easy
to understand—it’s either the address of a cell
containing a number, or a formula that results
in a number. The Format argument is any valid
number or date format. If you open the Format
Cells dialog box (by clicking the Dialog Box
Launcher in the Number group on the Home
tab) and select Custom, you’ll find many
examples of valid formats. Here are some samples:
Use Excel’s LEFT and RIGHT functions
to create a new inventory number.
You Can Use the & Sign
May 14, 2010
May 14, 2010
You can also perform this same task with the
following formula: =LEFT(A8,2)&RIGHT(B8,4).
The & sign essentially performs the same
task as the CONCATENATE function,
combining the results of the LEFT and
RIGHT functions into a single text string.
The Format argument must be enclosed
in quotations, as in =TEXT(G4,“m/d/yy”).
Suppose you run a construction business, and
you have a worksheet that everyone in your
department is supposed to update as soon as a
particular job is completed, listing the total cost
of that job, the number of weeks it took to
complete, and the approximate level of customer
satisfaction. You use this worksheet to create
a list of recent referrals for new clients, so it’s
pretty important that it’s updated often.