Yes, thank you. I was hoping for someway to "lock" the formatting, as there
are several users of this spreadsheet - some are not so computer savy.

"מיכאל (מיקי) אבידן" wrote:

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.