|
» Combining Text and a Formatted Date
CATEGORY: Excel Editing |
VERSIONS: 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") |
| Screenshot // Combining Text and a Formatted Date |
  |
|
RATING:
3.39
VIEWS: 21803 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- The One Page Business Plan: Start With a Vision, Build a Company!
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Accounting the Easy Way
- Dictionary of Finance and Investment Terms
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
