excel for mac 2016

Forum discussion tagged with excel for mac 2016.
  1. J

    [SOLVED] How to have "Excel for Mac 2016" Auto-convert entry of yymmdd to yyyy-mm-dd

    Hi, 
 I want to type, say, 20201008 or 201008 into a cell and as soon as I press the enter or tab key have "Excel for mac 2016" immediately convert either entry to 2020-10-08. 
 I don't want to have another column set up that uses a formula to convert 20201008 or 201008 to 2020-10-08. 
 I...