How can I set the paste option in excel to automatically format using the
destination settings?

I always have to click on the paste option to do this.

Cheers