Although most users rarely make use of the cell styles, this would be the logical way to deal with this.

If your source document cells all have a particular style applied to them (that includes a font of Arial 14) and the destination document has the same style name BUT with different settings (Calibri 12 with $ and "," separators) then you can simply copy and paste normally with no extra formatting steps required.



If you format cells by applying styles rather than adding local formatting then you will find transferring content between workbooks can be greatly streamlined.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia