You will have to do a Paste Special and choose Value. That way only the
number will come across, not the formatting.

"Ronan" wrote:

I'm copying data from one spreadsheet to another. When I do this, all
formatting (i.e. font color, borders, graph colors, etc.) for other tabs in
the copied to spreadsheet changes.

Any ideas on how to prevent this?

Thanks,
Ronan