How do I stop excel switching to US dates?

[Oliver Dewar]

Hi All,

I'm stuck!

I need my dates to display as UK dates DD/MM/YYYY.

I have a textbox on a userform in which the user inputs a date DD/MM/YYYY.

I have formatted the cell that the date get's put into as DD/MM/YYYY.

The problem is that the days and months are being swapped around when the date hits the cell... so:

07/12/2000 (7th of Dec 2000)

becomes 12/07/2000 (12 th of July 2000)

How can I stop this from happening?

 

[sykes]

Excel can be a bit of a pain like that...........

I suggest forcing the date by always formatting it in the code, when you throw it over from the textbox:

......sheets("sheet2").range("A1").value = format(userform1.textbox1.value,"DD/MM/YYYY")

Not tested, but it should do the trick. Obviously you'll need to change the references etc, but it should give you the gist. Just post back if it doesn't do the trick - and include your code as well.