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 2 of 2
  1. #1
    Member
    Join Date
    Jul 2013
    Posts
    42
    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

  3. #2
    Junior Member
    Join Date
    Jan 2021
    Posts
    2
    Member #
    9189
    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

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, 04:22 PM
  2. Replies: 1
    Last Post: 04-29-2014, 01: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, 03:56 PM

Contact Us
Back to top