Microsoft Office Tutorials and References
In Depth Information
Joining Text and a Number
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
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