Excel copy-paste: always match destination formatting

I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when pasting into Excel?

Can't set the default, but more convenient than fiddling with the paste options after each paste:

If you press the Backspace or F2 key before pasting text it will paste the text only, retaining the existing formatting.

source: http://appscout.pcmag.com/business-financial/272436-always-match-destination-formatting

I wonder why this works?

Simply double click on the cell first before pasting.

Try ALT+E+S+V+ENTER are the key strokes.

You could place a macro in your Personal personal excel workbook for pasting special, but you would not be able to undo the action after.