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
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)
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)
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).
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.
managed to fix somehow Office updates f**ked up my computer. empty the temps and rebooted everything start working
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.