How to have Excel for mac 2016 Auto-convert entry of yymmdd to yyyy-mm-dd

[JohnDohe]

Hi,

I want to type, say, 20201008 into a cell and as soon as I press the enter or tab key
have "Excel for mac 2016" immediately convert that entry to 2020-10-08.

I don't want to have another column set up that uses a formula to convert
20201008 to 2020-10-08.

I want Excel to do the conversion in the background, or as a formula for that cell,
but that it works to allow me to type into that cell 20201008 and as soon as I press
the enter or tab key the cell displays 2020-10-08.

Anyone got a way to do this?

Thanks!

[Ads]