+ Reply to Thread
Results 1 to 16 of 16

The way I entered date

  1. #1
    Registered User
    Join Date
    12-13-2019
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    8

    The way I entered date

    I have my date formatted for November 30, 2019 on my invoice. I used to be able to just enter 11/30/19 and it would come up as the formatted date that I want (November 30, 2019). Now if I enter 11/30/19 it comes up as June 7, 2209. What's happening?

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,436

    Re: The way I entered date

    I don't know what you are doing but the date June 7, 2209, is stored in Excel as the number 113019. So if you are typing 11/30/19 somehow the "/' characters are being ignored. Next time you type 11/30/19 look carefully at what you typed before you hit ENTER.

  3. #3
    Registered User
    Join Date
    12-13-2019
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    8

    Re: The way I entered date

    OK so now I CAREFULLY entered 11/30/19 with the /// and it comes up as 11/30/19 even though I formatted it to be November 30, 2019. I never had this problem with my older version of excel, I shouldn't have to type the date in.
    Last edited by barblb; 12-13-2019 at 06:01 PM.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,436

    Re: The way I entered date

    This is not normal. Can you please attach your file? The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,552

    Re: The way I entered date

    Is it possible this is due to a change in the Window's date setting? https://www.howtogeek.com/247141/how...es-in-windows/ Has your Window's default date format setting recently changed, and Excel is using your OS setting to understand default date entry?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Registered User
    Join Date
    12-13-2019
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    8

    Re: The way I entered date

    It is possible,;however, I have tried on two different computers. on the bottom of one of the computer's screen the date shows as 12/16/2019 and on the other computer screen it shows as 16-Dec-2019. What do you suggest I change it to? Right now the short date is mm-dd-yyy and the long date is same format Thanks
    Last edited by barblb; 12-16-2019 at 03:54 PM.

  7. #7
    Registered User
    Join Date
    12-13-2019
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    8

    Re: The way I entered date

    Here is a sample invoice i've attached
    Attached Files Attached Files
    Last edited by barblb; 12-16-2019 at 04:05 PM.

  8. #8
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,552

    Re: The way I entered date

    I don't replicate the issue. I can enter 11/30/19 in D4 (or anywhere else in the spreadsheet) and it correctly stores the date as serial number 43799 (the serial number for 30 November 2019). Is there more to replicating the issue? If I change my OS settings to a different short date format, then the spreadsheet no longer recognizes 11/30/19 as a date, but enters it as that exact text string. I cannot replicate the issue where I enter 11/30/19 and get some date way in the future.

  9. #9
    Registered User
    Join Date
    12-13-2019
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    8

    Re: The way I entered date

    What short format was your date on? I am stumped, I've never had this happen before. It's strange because I got a new laptop and thought maybe that was why, but the same thing is happening on my old desktop. ???? HELP LOL

  10. #10
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,552

    Re: The way I entered date

    I chose one of those that used dashes "yyyy-m-d"

  11. #11
    Registered User
    Join Date
    12-13-2019
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    8

    Re: The way I entered date

    I just tried that I get January 31, 2237. Could it be a recent update that I downloaded may have screwed things up for me?

  12. #12
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,552

    Re: The way I entered date

    I'm running Excel 2007 under Windows 7, so I am just a couple of weeks away from being a totally out of date outcast. I have no idea what any recent updates to Office or Windows may have done.

    I don't know exactly what you tried, but 31 Jan 2237 is serial number 123119. Maybe you tried entering 31 Dec 2019?

    I do not recall ever having this kind of trouble where Excel ignores a date separator and enters the number like you are describing. In my experience, when I use a date separator that Excel recognizes, then it enters the date. If you use a date separator that Excel does not recognize, then it treats the entry as text. I do no have any experience where Excel just ignores the date separator and enters the number as if not separator had been used.

  13. #13
    Registered User
    Join Date
    12-13-2019
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    8

    Re: The way I entered date

    My apologies, I think I entered it without the slashes again. When I enter 12/31/19 that's exactly what comes up whereas before it would come up as December 31, 2019
    That is the format I have set up for that cell. And I did this on my old desktop which has windows 7 as well. LOL I'm not giving up. Thanks for trying.

  14. #14
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,436

    Re: The way I entered date

    Are you talking about entering the date in cell D4? I type in 12/31/19 or any other date is it comes up as December 31, 2019, or whatever the date is. When I first opened the file it correctly displayed a date of November 30, 2019, before I did anything.

    You have got some issue that is specific to your computer, rather than a problem with this file. Try creating a new clean file and just type in 12/31/19 into any cell (do not format anything!) and see what happens.

  15. #15
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,082

    Re: The way I entered date

    what does D4 show when you key ctrl+;
    what does D4 show if you type =Today() in it?
    Ben Van Johnson

  16. #16
    Registered User
    Join Date
    12-13-2019
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    8

    Re: The way I entered date

    ctrl+; shows 12/18/2018
    so does =today()

    For some reason I think it is working now I just enter 11/30 and it shows November 30, 2019

    I tried a few things I found on the internet. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 02-15-2017, 08:00 AM
  2. [SOLVED] if data is entered in column A, column B should have date automatically entered.
    By exceltriumph in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2016, 12:02 PM
  3. Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  4. Popup box asking the effective date, so macro can delete any dates < entered date.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2013, 07:40 AM
  5. how to force a date field to be entered so my pop up calendar appears to pick date
    By cmwilbur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2010, 10:19 AM
  6. Replies: 0
    Last Post: 05-25-2009, 06:58 PM
  7. Replies: 3
    Last Post: 05-28-2008, 01:32 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1