Protecting cells in Excel so that users can only paste in text
 

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

Protecting cells in Excel so that users can only paste in text
 

don't think so.you could have them paste to a blank sheet
then copy it in, or use code to get th edata from the
file or finally, use code to re-format the data after the
import.

-----Original Message-----
Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?

.