Hi I've got a big spreadsheet running on a very slow machine and I need to
paste a lot of info into it from many different sources all by different
authors, the last thing I need to be doing is adjusting the formatting after
each paste or going through the "paste special" menu and selecting "text" for
each one.

So the question is: can I make the formatting of the cell take precedence
over that of the copied text?