+ Reply to Thread
Results 1 to 3 of 3

Cell linked to Microsoft MonthView Control not formatting date correctly.

  1. #1
    Registered User
    Join Date
    09-26-2016
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    3

    Cell linked to Microsoft MonthView Control not formatting date correctly.

    Hello, I have set up a Microsoft MonthView Control drop down box to make it easy to select a date to input into an Excel 2016 (Office 365) form. The format on the drop down is set to dtpLongDate which correctly displays in the format January 1, 2000. I then have that date selection linked into a blank cell on the spreadsheet, but the date format in that linked cell does not format correctly. It always displays in the format 2000-01-01. I have tried setting the format cells on that linked cell to general, text or date, but it always displays in the format 2000-01-01 no matter what I change it to. If I manually type in the date it will change to the correct format Month Day, Year, but it will never display in the same correct format as the date drop down box when linked. Any ideas what might be causing this behavior? I have tested it in numerous different cells within a number of different workbooks, but the date format will not correct itself.

    Jeff

  2. #2
    Registered User
    Join Date
    09-26-2016
    Location
    Saskatchewan, Canada
    MS-Off Ver
    2016
    Posts
    9

    Re: Cell linked to Microsoft MonthView Control not formatting date correctly.

    Did you check your regional settings? This may be this issue.

  3. #3
    Registered User
    Join Date
    09-26-2016
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Cell linked to Microsoft MonthView Control not formatting date correctly.

    Regional settings appear to all be set correctly. Under "date and time formats" the short date is set to yyyy-MM-dd and the long format is set to MMMM d, yyyy. Nothing else looks incorrect.

+ 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. Monthview control switch the date format
    By rfbgb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2016, 11:44 AM
  2. Microsoft Monthview .visible = True not working
    By ckreitel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2016, 04:45 PM
  3. How to install date picker in UserForm: not seeing Monthview control in References
    By Pimp_mentality in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2015, 04:38 PM
  4. Monthview/Date time picker control? Help
    By jsabo in forum Excel General
    Replies: 0
    Last Post: 08-25-2013, 05:48 PM
  5. Microsoft Date & Time Picker Control - Linked Cell Query - Can anyone help?
    By ChrisBester in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 06:26 AM
  6. Insert SEP Date Control linked to cell
    By caherine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2012, 04:59 PM
  7. Insert SEP Date Control linked to cell
    By caherine in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2012, 04:31 PM

Tags for this Thread

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