Instead of "regular" Paste - try 'PasteSpecial' Values' 'OK'
Micky


"David" wrote:

Excel 2003 - I have a spreadsheet that has various cells with different types
of formatting - ie: bold / shade / font size etc. When a user copies / pastes
from text from 1 cell to another, it carries over the formatting as well as
the text - I want just the text to be copied.