- #1
JDD
- 15
- 0
- TL;DR 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!