Microsoft Office Tutorials and References
In Depth Information
Joining Text and a Number
Figure 9.9.
Figure 9.9. Joining text with a date or with formatted numbers rarely works
Joining text with a date or with formatted numbers rarely works
well.
well.
In this case, you need to discover the numeric formatting code associated with
the original cell. To do so, follow these steps:
11. Select cell D2.
22. Press Ctrl+1 to display the Format Cells dialog.
33. On the Number tab, choose the Custom category. This reveals the ac-
tual formatting codes for the cell.
As shown in Figure 9.10 , the actual formatting code for B2 is $#,##0.00. If you
repeat these steps for cell D4, you learn that the actual formatting code is
m/d/yyyy.
Search JabSto ::




Custom Search