0
Undo
Votes
Hi,
I want to type, say, 20201008 into a cell and as soon as I press the enter or tab keys
have "Excel for mac 2016" immediately convert that entry to 2020-10-08.
I don't want to have another column set up that uses a formula to convert
20201008 to 2020-10-08.
I want Excel to do the conversion in the background as soon as I finish press
the enter or tab key after entering 2020-10-08.
Anyone got a way to do this?
Thanks!
I want to type, say, 20201008 into a cell and as soon as I press the enter or tab keys
have "Excel for mac 2016" immediately convert that entry to 2020-10-08.
I don't want to have another column set up that uses a formula to convert
20201008 to 2020-10-08.
I want Excel to do the conversion in the background as soon as I finish press
the enter or tab key after entering 2020-10-08.
Anyone got a way to do this?
Thanks!
- Page :
- 1
There are no replies made for this post yet.