You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Level 1

31 points

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

Top-ranking reply

Level 10

195,485 points

Posted on Oct 8, 2020 8:31 AM

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 in context

Similar questions