Protect Cells Question
 

Hi,
I have a worksheet that I protected some cells to prevent data entry.
In my unlocked cells the format can't be modified by changing cell formats
with the "format cells" menu. When I copy and paste information from other
worksheet the format changes. Is there any way of keeping the format when I
paste information from other spreadsheet (without using past values)?
You help is much appreciated...
Thanks.