» Format number in joining text with linked number in Microsoft Excel
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
Example: Format a number without decimal places, with a thousands separator, and combine it with text.
- In cell A1, enter the text "You still owe the sum of".
- In cell A2, enter the number - 5434.
- In cell A3, enter the text "for invoice # 2232 from 6/15/2001".
- In cell A4, enter the formula =A1&""&TEXT(A2,"#,##0")&""&A3.
Formatting a number with the thousands sign - the letter K
The formula =A1&" "&TEXT(A2,"#,K")&" "&A3
The sentence appearing in the cell - "You still owe the sum of 5K for invoice # 2232 from 6/15/2001".
Book Store:
Recommended Books:
- Accounting Principles, with CD, 6th Edition
- How to Read A Financial Report
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Microsoft Office XP Step-By-Step (With CD-ROM)
Format example
confused
result are #NAME? from your tip " Format number in joining text with linked number in Microsoft Excel" emailed 3/30/06
making easy with graph
AD Asham
if the formulas should be describe with tables
