Learn Excel Episode 798: Typing Months

Posted in Companies, Podcasts on July 17, 2008



Go to a cell in Excel and enter July 2008 as 07/08. Unfortunately, Excel will convert this to July 8 of the current year. In Episode 798, a bit of VBA code to convert that entry back into a month and year.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, VBA