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

This is a discussion on How to have Excel for mac 2016 Auto-convert entry of yymmdd to yyyy-mm-dd within the Mac Applications forums, part of the Mac Software category; 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 ...

Results 1 to 1 of 1
  1. #1
    Member
    Join Date
    Jul 2013
    Posts
    40
    Member #
    6046

    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!

  2. Ads

    Posts
    Many

Remove Ads

Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Similar Threads

  1. This is entry level?
    By ardchoille in forum Mac Mini
    Replies: 7
    Last Post: 06-09-2014, 03:22 PM
  2. Replies: 1
    Last Post: 04-29-2014, 12:43 PM
  3. Entry-Level MacBook Pro Now Costs $999 For Students
    By sparkyscott21 in forum MacBook Pro
    Replies: 0
    Last Post: 05-30-2013, 02:56 PM

Contact Us
Back to top