locking cell format only

T

tim

Is there a way to lock only the cell format? I want to be
able to copy and paste data from one cell to another
without changing the cell formating. I would like to do
it without using paste special or a macro.
 
D

Dave Peterson

If your cells are constants, you could copy from the formula bar and paste into
the formula bar.
 
Top