Forcing UK date format in Date command

[Glio]

I have the code below working as I want it to, when data is input in column 2 the date and time is automatically input into the corresponding cell 3 columns to the right. I want to ensure that the date is changed to the UK format dd-mmm-yy. I have formatted the column to be in that format but for some reason it has suddenly started changing the date to US format.

Can this code be changed to force the date to be in UK format?

Please Login or Register  to view this content.

Regards

Geoff

[royUK]

Try this

Please Login or Register  to view this content.

[Glio]

RoyUK,

As usual you have come up trumps

Thanks very much

Geoff

[royUK]

No problem, I forgot to say you originally unprotected the sheet twice.

Can you mark the thread solved?