1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Date shortcut posts proper date and then changes

Discussion in 'Business Applications' started by shredr, May 14, 2016.

Thread Status:
Not open for further replies.
  1. shredr

    shredr Thread Starter

    Aug 21, 2011
    Excel 2013 and Windows 10 Pro

    Today is May-14

    Date format is set to show: Mar-16
    Pressing Ctrl+; shows: 05 14 2016 in the cell
    and it converts to: May-16 after I exit that cell.

    Any ideas as to how to fix this or why it adds 2 days to the date?

    I don't do much on computer now because of health but when I do and there is a problem, I know some of the experts are here.

    Thank you in advance, Ron
  2. Xsage


    Jan 8, 2016
    First Name:
    Hey Ron,

    This should be a fairly simple one. I'd hazard a guess and say the May-16 is the month and year rather than the month and day.
    If you click the format drop down as shown below, and click the last option for more formatting options.


    In the box that pops up, navigate to Custom using the left hand panel to navigate.
    Here you can make your own (or use a preset if you wish) format to suit your needs.


    Here is a quick key to help you get by:
    dd = Day in Number format
    ddd = Day in Short text
    dddd = Day in Long text
    mm = Month in Number format
    mmm = Month in Short text
    mmmm = Month in Long text
    yy = year in 2 digits
    yyyy = year in 4 digits

    You can separate these with pretty much whatever you want.
    All of this data is input into the "Type" field as shown in the picture above.

    See the picture for an example, Ironically it is May 16th today so it will appear the same as your issue does, but rest assured, as long as you have those D's in there, it will display the day!

    Best of luck,
    Let us know how you get on,

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1171310

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice