» Combining Text and a Formatted Date
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To combined text with a formatted date:1. In cell A1, enter the text The book publication month is.
2. In cell A2, enter the date 02/01/2004.
3. In cell A3, enter the formula:
=A1&" "& TEXT(A2,"mmmm yyyy")
Book Store:
Recommended Books:
- Mastering Excel 2000 (for beginner)
- The Analysis and Use of Financial Statements
- Harry Potter and the Order of the Phoenix (Book 5)
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Business Plans Kit for Dummies (With CD-ROM)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
No comments have been submitted.
