» Combining Text and Formatted Values
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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


Book Store:
Recommended Books:
- Definitive Guide to Excel VBA
- Microsoft Access 2002 for Dummies
- Keys to Reading an Annual Report (Barron's Business Keys)
- Investing for Dummies, Third Edition
- Financial Statement Analysis with S&P insert card
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
Combing Text and Formatted Values
Stephanie Davis
Great Tip, but how would you combine text with dates? They come out as numbers???? I want a start date Jan 1, 2006 and Jan 3, 2006 to be combined to read Jan 1 - 3, 2006 OR at least Jan 1 - Jan 3, 2006. Test is the dash.

