Locking a format
 

How do I lock the format but still allow a user to input values into a cell?

I have cells that are unlocked to allow for operator entry but if the
operator copies and pastes from another spreadsheet, the format I've set up
changes to whatever the copied and pasted cell had.

thanks

Irie!