» 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:
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Windows XP All-in-One Desk Reference For Dummies
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
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
