|  

» Combining Text and Formatted Values

To combine text with a formatted value:

1. In cell A1, enter the text IBM owe Limelight Media Inc.
2. In cell A2, enter the number 4222.
3. In cell A3, enter the text for services supplied in March 2004.
4. In cell A5, enter the formula:
=A1&" "& TEXT(A2,"$ #,##0") &" "&A3

To format the number to present it in thousands:

Change the number format to "$ #, K":
=A1&" "& TEXT(A2,"$#, K") &" "&A3

Screenshot // Combining Text and Formatted Values
Combining Text and Formatted ValuesCombining Text and Formatted Values
Rate This Tip
12 34 5
Rating: 3.11     Views: 35184
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments