» 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:
- Business Plans Kit for Dummies (With CD-ROM)
- Windows XP Pocket Reference
- Microsoft Windows XP Registry Guide
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Word 2002: The Complete Reference
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
No comments have been submitted.
