Every time I enter a date as m/d and exclude the year, it automatically changes the date to dd-Mmm even though the rest of the table column is already (re)formatted as Short Date m/d/yyyy. It won't keep the short date format and just let me enter dates as m/d (all the dates i'm entering are for the current year).
What can I do to change this? Is there a vba function that can detect that 'custom' format of dd-Mmm and change it back to short date after you've typed in the date?