Microsoft Office Tutorials and References
In Depth Information
Joining Text and a Number
Figure 9.10.
Figure 9.10. If you choose the Custom category, you learn the actual codes
If you choose the Custom category, you learn the actual codes
used to produce the numeric format.
used to produce the numeric format.
For a complete discussion of numeric formatting codes, see
see
Chapter 30 , Formatting Worksheets .
When you know the numeric formatting codes, you can achieve the desired ef-
fect by using those codes, enclosed in quotation marks, as the second argu-
ment of the TEXT function. In Figure 9.11 , the formula in cell E2 is ="The price
is "&Text(D2, "$#,##0.00"). You can use your knowledge of custom numeric
formatting codes to change the look of the joined value. In cell E4, the new
formula is ="His birthday is "&TEXT(D4, "dddd mmmm d, yyyy").
Search JabSto ::




Custom Search