Cell Formatting, Copy from other formatted worksheet

[cageman]

I would like to protect the formatting of some cells where I copy data from another worksheet but don't want that particular format in the current worksheet. How do I do this? I have tried Conditional Formatting but this doesn't work. I just want to enter in text and not change the template that I have made. Thanks for any help!

 

[Datsmart]

When you Copy and Paste, choose Paste Special - Values

Copy as normal,
Right Click where you want to paste, choose Paste Special, Values, OK.

 

[Geoff H]

Use... edit / paste special / values.
this will not transfer the formatting from the donor sheet, and will keep the formatting of the recipient sheet