From a YouTube Viewer, Bill looks how to have text and actual dates reside in the same Cell. Follow along with Episode #1517 to learn how to add Custom text to your Date Field while retaining the actual Date.

[youtube=http://www.youtube.com/watch?v=9aqz7YJyZKU]

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!