» Combining Text and Formatted Values
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Seven Habits Of Highly Effective People
- Special Edition Using Microsoft Outlook 2002
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.
