» 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:
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Learn MS Excel 2002 VBA/XML Programming
- Investing in Real Estate, Fourth Edition
- Microsoft Office XP Introductory Concepts and Techniques
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
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.
