I'm using Microsoft Excell 2003 from Office 2003 Professional. What I'm
trying to do is copy and paste numbers from a statistics table online into my
open workbook. Now I can enable and disable the "paste options" button that
appears when I paste the number. from the button the options are to "Keep
source formatting" or "Match Destination Formatting". The default is to "keep
source formatting" and that wont show up in the workbook correctly. What I
want to know is can I change any options so that no matter what I copy and
paste it will match the formatting of my workbook by default and give me the
choice to keep source formatting as an option instead of vis-versa.