Facepalm

Ctrl + v

There's a multitude of different paste options in Excel, based on whether you want to copy the whole cell, just the value, the formula that produced the value, just the format, a link to the original cell, or an assortment of more specialized options.

So Ctrl+V does work, but it doesn't always paste what you thought you copied.