Could you attach an example of a workbook you're copying FROM, and a workbook which has the sheet you're copying to. Normally, numbers would be copied as numbers, so I'll be looking for why this is copying as text.