I have a rather large principle worksheet that has several formats (dates, currency, etc.) and font types and sizes. It is necessary to transfer unformatted data from other worksheets into our principle worksheet and have this data convert to the format in the principle worksheet. How can I set up the formats in the principle worksheet so when transferring data is it not converted to unformatted data. Thank You.
Frank
