Thread: Lock formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hfazal hfazal is offline
external usenet poster
 
Posts: 22
Default Lock formatting

Hi, how can I set up a cell/group of cells so that the data in them can be
changes but the formatting cannot. For instance if I put the number
formatting as a percentage to 5 decimal places, then even if someone
copy/pastes something from a different cell that is not in that format, the
cell will take the new input without taking the formatting...

Thanks
HF