Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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 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
Question marked as Apple recommended

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:


  • View: YouTube


Posted on Oct 8, 2020 8:31 AM

Similar questions

2 replies
Question marked as Apple recommended

Oct 8, 2020 8:31 AM in response to drffc

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:


  • View: YouTube


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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.