» 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:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Wall Street Journal Guide to Understanding Money and Investing
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Business Analysis with Microsoft Excel (2nd Edition)
- Windows XP for Dummies
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
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
