Hello,

I did some searches and although I found some other threads discussing
this, I found no working solution. I suspect what I want cannot be
done, but I am asking anyway in case there is a solution that was
missed or perhaps a method became available in later versions of Excel
or via patches.

I would like to lock or freeze the format of a cell, so that a user can
copy a value from another cell to it, without the format also being
copied. I realize this can be done with 'Paste Special', but I find
that method too cumbersome to expect my users to use.
I am using Excel 2003 (11.6113.5703).

Thanks,
Tim