Hi,

I'm trying to copy cell content from a previous version of a worksheet to a
new updated version, but the copy/paste facility seems to copy the cell
formatting as well as the cell data across.

Is it possible to select cells and only copy the data contained within so as
not to alter the destination cell formatting? This applies to conditional
formatting and validation settings that I don't want overwritten.

Thanks,

Nick