Advice to locate bug etc regarding date format in excel items

[ipbr21054]

Morning,
My pc date format is set at dd/mm/yyyy

In various worksheets i have codes relating to date.
Examples
1,Double click on cell in column A i then see 04/02/2019 as opposed to 02/04/2019

2,On a userform a text box is shown as 05/04/2019 i then transfer data from userform to worksheet.
The userform is still open so i can enter another set of data BUT i now notice that the text box date is now showing as 04/05/2019
The date has now changed from dd/mm/yyyy to mm/dd/yyyy,the date now stays as mm/dd/yyyy but if you close the form then open it again then it is shown as dd/mm/yyyy but as soon as you make a transfer it reverts back to mm/dd/yyyy

Any advise please

 

[tyija1995]

Not sure if this will fix the problem but is your Locale set to "English (United Kingdom)"?
You can find Locale under Format Cells -> Number (Tab) -> Date (Category)
your PC may be showing as UK date but Excel might be referring to US or other date?

 

[ipbr21054]

Hi,
Yes,just checked and shown as English United Kingdom