How to have Excel for mac 2016 Auto-convert entry of yymmdd to yyyy-mm-dd


Joined
Aug 12, 2017
Messages
46
Reaction score
1
Hi,

I want to type, say, 20201008 into a cell and as soon as I press the enter or tab key
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, or as a formula for that cell,
but that it works to allow me to type into that cell 20201008 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!
 
Ad

Advertisements

Joined
Jan 25, 2017
Messages
1,166
Reaction score
87
1. Select the range of cells you wish to format.
2. Right-click the selection and click "Format Cells." The Format Cells dialog window opens.
3. Select Number
4. Click "Custom" at the bottom of the Category list.
5. Click the text field below "Type."
6. Enter 0000-00-00
7. Click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top