Hi, I need some help please!

I've designed a sheet to collect data from users which has been set up with
lots of set formats (e.g round £ to two decimal places). That's fine and I'm
happy with what it's doing.

The problem that I'm having is that some users are just copying and pasting
chunks of data from other data bases into the sheet and I'm loosing all the
set formats that have set up.

My question is: How do I allow users to both, type the data in, or paste
data in and the sheet to retain the formats that I've set up! Any help or
suggesions would be appreciated.

Many thanks,

MM