» 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:
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Mastering Excel 2000 (for beginner)
- Accounting Principles, with CD, 6th Edition
- Good to Great: Why Some Companies Make the Leap... and Others Don't
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.
