Using Excel 2013 .....
I have a button that when double-clicked, enters today's date.
The problem is that it is entered on to the sheet in American format (mm/dd/yyyy).
For today, it incorrectly displays 12/11/2018 instead of the correct UK formatted 11/12/2018
(G46 Should read ... EE 0 Days Ago)
G47 is correctly formatted and Win10 Locale is set to UK
Why could this be happening?
(If I incorrectly set the format of the vba to American it works .... a most unsatisfactory workaround)
Private Sub CommandToday2_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Range("G47").Value = Format(Now(), "dd/mm/yyyy")