I am copying select cells from one workbook to another using Past Values
(using the toolbar button to paste). The value pastes, but if I hit enter
(rather than the down arrow), the value I just pasted reverts to the
formula/formatting of the cell I copied from. Is there an option I can access
to turn this off?