» 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:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Mastering Excel 2000 (for beginner)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Financial Peace: Revisited
- Microsoft Word Version 2002 Inside Out
No comments have been submitted.
