» Combining Text and a Formatted Date
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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:
- The Fall of Advertising and the Rise of PR
- The Interpretation of Financial Statements
- Marketing Management
- Special Edition Using Microsoft Access 2002
- Microsoft Office XP Introductory Concepts and Techniques
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
No comments have been submitted.
