Results 1 to 2 of 2
-
10-08-2020, 10:34 AM #1
How to have Excel for mac 2016 Auto-convert entry of yymmdd to yyyy-mm-dd
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!
-
10-08-2020 10:34 AM
-
01-10-2021, 09:29 AM #2
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
Remove Ads
Similar Threads
-
This is entry level?
By ardchoille in forum Mac MiniReplies: 7Last Post: 06-09-2014, 04:22 PM -
Microsoft announces new Office for iPad apps including Word, PowerPoint, & Excel
By sparkyscott21 in forum Apple for BusinessReplies: 1Last Post: 04-29-2014, 01:43 PM -
Entry-Level MacBook Pro Now Costs $999 For Students
By sparkyscott21 in forum MacBook ProReplies: 0Last Post: 05-30-2013, 03:56 PM