Hi folks

A question i'm sure most of you can help with:

I need to force the date in column b to always default to the following format

DD/MM/YYYY

Because some idiots like to put is like this:

DD.MM.YYYY

even if i format the cell to have the format that i desire the user can still enter the date with the fullstops!!

any idea's on how to stop this?

I Appreciate you reading this and cheers for any help folks!!