Windows 10 Date

Discussion in 'Windows 10' started by cyberbot, Sep 7, 2015.

  1. cyberbot

    cyberbot MDL Senior Member

    Joined:
    Jul 30, 2011
    Messages:
    475
    Likes Received:
    20
    Trophy Points:
    10
    #1 cyberbot, Sep 7, 2015
    Hi Guys,
    using excel 2013 in one of my windows 10 machine, however windows 10 date formate is dd/mm/yyyy but excel is still seeing it as mm/dd/yyyy
    tried to change the date on windows settings and excel but its still not changing.
    any suggestions how to fix this ?
    thank you
     
  2. odiebugs1

    odiebugs1 MDL Expert

    Joined:
    Jul 30, 2015
    Messages:
    1,390
    Likes Received:
    461
    Trophy Points:
    60
    #2 odiebugs1, Sep 7, 2015
    Last edited: Sep 7, 2015
    So in settings you've changed format and it doesn't work ?.

    HKEY_CURRENT_USER\DEFAULT\Control Panel\International
    Value name: sShortDate, Value data: dd/MM/yyyy (or any other format)
     
  3. cyberbot

    cyberbot MDL Senior Member

    Joined:
    Jul 30, 2011
    Messages:
    475
    Likes Received:
    20
    Trophy Points:
    10
    #3 cyberbot, Sep 7, 2015 (OP)
    yes on the right corner of my windows it says 07-09-2015
    and the VAPProject on excel is

    TextBox6.Value = Format(Date, "dd-mm-yyyy")
    TextBox7.Value = Format(DateAdd("d", 30, TextBox6.Value), "dd-mm-yyyy")
    TextBox8.Value = Application.VLookup(Me.ComboBox1, Sheets("Addresses").Range("A:G"), 7, False)
     
  4. odiebugs1

    odiebugs1 MDL Expert

    Joined:
    Jul 30, 2015
    Messages:
    1,390
    Likes Received:
    461
    Trophy Points:
    60
    #4 odiebugs1, Sep 7, 2015
    Last edited: Sep 7, 2015
    Have you tried format cells -Custom

    Select the column containing the dates, go to Data and choose Text to Column, choose delimited and click next
    and uncheck all delimiters and click next, Click on date and choose right format for the dates (default DMY).
     
  5. cyberbot

    cyberbot MDL Senior Member

    Joined:
    Jul 30, 2011
    Messages:
    475
    Likes Received:
    20
    Trophy Points:
    10
    #5 cyberbot, Sep 7, 2015 (OP)
    how I am supposed to do this ?
    can you explain please ?
     
  6. odiebugs1

    odiebugs1 MDL Expert

    Joined:
    Jul 30, 2015
    Messages:
    1,390
    Likes Received:
    461
    Trophy Points:
    60
    #6 odiebugs1, Sep 7, 2015
    Last edited: Sep 7, 2015
  7. cyberbot

    cyberbot MDL Senior Member

    Joined:
    Jul 30, 2011
    Messages:
    475
    Likes Received:
    20
    Trophy Points:
    10
    #7 cyberbot, Sep 7, 2015 (OP)
  8. RCM

    RCM MDL Junior Member

    Joined:
    May 15, 2010
    Messages:
    90
    Likes Received:
    50
    Trophy Points:
    0
    #8 RCM, Sep 7, 2015
    You can change it in excel, right click on cell or group of cells, chose format cells, click on "date" then choose the format you want.
     
  9. cyberbot

    cyberbot MDL Senior Member

    Joined:
    Jul 30, 2011
    Messages:
    475
    Likes Received:
    20
    Trophy Points:
    10
    #9 cyberbot, Sep 7, 2015
    Last edited: Sep 7, 2015
    (OP)
    managed to fix
    somehow Office updates f**ked up my computer.
    empty the temps and rebooted everything start working
     
  10. odiebugs1

    odiebugs1 MDL Expert

    Joined:
    Jul 30, 2015
    Messages:
    1,390
    Likes Received:
    461
    Trophy Points:
    60
    #10 odiebugs1, Sep 7, 2015
    Wow, thank goodness it wasn't one of them and it was temp folder, I have I think a hundred updates for office.

    Glad it worked out and you're all set, honestly wasn't thinking of this one, could have run through too many things to try.
     
  11. cyberbot

    cyberbot MDL Senior Member

    Joined:
    Jul 30, 2011
    Messages:
    475
    Likes Received:
    20
    Trophy Points:
    10
    #11 cyberbot, Sep 11, 2015 (OP)
    thank you for even trying to help me,
    yes those updates can be bad sometime