Always keeping source formatting when copying and pasting in Excel
 

I have upgraded to Excel 2007. Now when I copy something from a 2003
spreadsheet and then paste it into another spreadsheet (in compatability
mode) everything in the text box ends up right justified. I have a pop-up
box that gives me the option to keep source formatting, which then puts the
text back the way it should be. Is there a way to always keep source
formatting without having to do this for each thing I copy and paste?