- #1

- 15

- 0

- Summary:
- Excel for Mac 2016

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!

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!