Mike Mayer wrote:
Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?


Not directly
The best you can do is disable or remove the ability to paste other
than Paste / Values.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup