I mis stated a bit, I'm actually getting the data from an access database
using the .copyfromrecordset method...

thanks for the useless, and rude post..

"Mike" wrote:

Start learning to use Paste Special.

"TomHinkle" wrote:

I've got a workbook that copies columns of data to different worksheets. On
one of the copies, the data is of the 'double' data type (ie a numeric with
decimal places). Every time it copies, it changes the data type in this
column to the date format.

Any ideas why this happens or how I can stop it??