convert text to date

Forum discussion tagged with convert text to date.
  1. J

    [SOLVED] How to have "Excel for Mac 2016" Auto-convert entry of yymmdd to yyyy-mm-dd

    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 either entry to 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...
    • John Dohe
    • Thread
    • convert text to date Excel excel for mac 2016
    • Replies: 19
    • Forum: macOS
COMPANY
RESOURCES
FOLLOW
Top Bottom