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

Question

Level 1

33 points

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 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 or 201008 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!

Posted on Oct 8, 2020 7:56 AM

Reply

Answer 1

Level 10

203,019 points

drffc Said:

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

———-

Creating Strings in the Formula Box:

This all has to do with creating strings. Strings contain formulas (pound signs for “All” and Ampersands for “part”). So, use these methods:

Reply

Answer 2

You might try asking your question in the Microsoft Product Help Communities.

Reply

Similar questions