I'm afraid you have to change your Windows/Regional Settings/Language from
English US to English UK.
Regards,
Stefi


€žtina€� ezt Ã*rta:

Hi
I have a macro which request a date which is then used in an advanced filter
My problem is the date seems to be american format mm/dd/yy but i need uk
the cell g2 is formatted to dd/mm/yy but comes out as mm/dd/yy after
inputbox used
MYDATE = InputBox("ENTER DATE DD/MM/YY")
Range("G1") = "<="
Range("G2") = MYDATE
how do I format inputbox?
thanks Tina