» 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:
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Mortgages For Dummies®
- A Mathematician Plays the Stock Market
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
