You can use Paste Special feature.
Not quite sure where the button is in 2007, but the command path is
ALT, E, S. In order, not at the same time.
It'll pull up the paste special feature, and you can select pasting the formatting as well as the values.