|
» Format number in joining text with linked number in Microsoft Excel
CATEGORY: Excel Format |
VERSIONS: All Microsoft Excel Versions |
|
Example: Format a number without decimal places, with a thousands separator, and combine it with text.
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". |
| Screenshot // Format number in joining text with linked number in Microsoft Excel |
  |
|
RATING:
3.21
VIEWS: 44787 |
||||
Format example
confused wrote on December 31, 1969 19:00 EST
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 wrote on December 31, 1969 19:00 EST
if the formulas should be describe with tables
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Business Analysis with Microsoft Excel (2nd Edition)
- Accounting and Financial Fundamentals for Nonfinancial Executives
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Excel Version 2002 Step by Step
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
