» 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:
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Intelligent Investor: The Classic Bestseller on Value Investing
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Marketing Planning for Services
No comments have been submitted.
