+ Reply to Thread
Results 1 to 3 of 3

Problem with Date column reverting to the same date

  1. #1
    Registered User
    Join Date
    03-09-2018
    Location
    us
    MS-Off Ver
    14
    Posts
    11

    Problem with Date column reverting to the same date

    I have uploaded this spreadsheet, and the date column consistently reverts back to the same date, and it should not have a date unless entered day month year, please help urgently.

    Thank you

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Problem with Date column reverting to the same date

    No attachment.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: Problem with Date column reverting to the same date

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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: 5
    Last Post: 05-03-2017, 02:12 PM
  2. UserForm Date reverting to US format
    By D3stijl3 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-04-2014, 09:36 AM
  3. Problem sorting the date column
    By Chris365 in forum Excel General
    Replies: 13
    Last Post: 02-14-2014, 03:54 AM
  4. Userform date format reverting back to us format on change event
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2009, 12:34 PM
  5. [SOLVED] problem sorting a date column
    By Middletree in forum Excel General
    Replies: 2
    Last Post: 08-16-2006, 09:15 AM
  6. problem of copying column related to date
    By news in forum Excel General
    Replies: 3
    Last Post: 05-12-2006, 05:23 PM
  7. Replies: 1
    Last Post: 10-12-2005, 05:05 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