Solved How to have Excel for Mac 2016 Auto-convert yyyymmdd entry

October 8, 2020 at 08:23:46
Specs: Mojave, 64 GB
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 and
display either entry as 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, again, in the background, 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!

See More: How to have Excel for Mac 2016 Auto-convert yyyymmdd entry


#1
October 9, 2020 at 08:15:31
✔ Best Answer
You need to click the Home screen > Format > Format cells. Now, click on the dialogue box, you will see 'Date' about halfway down the list. The format yy-mm-dd is one of the standard options in the Date selection box. Now, choose the cells you wish this formating to apply.

Reply ↓  Report •
Related Solutions


Ask Question