Wouldn't it be simpler to do all the pasting and forget about the format.

Then select all of the pasted range and just format it the way you want?

(I guess that assumes that all the cells that you pasted get the same format.)

Karsa wrote:

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?

--

Dave Peterson