The only way i can import the data i need is copy and paste. The trouble is that when i do this column E is in fractions i.e 5/6 and this is always shown as a date. Is there anyway to disable this? I know you can disable date reconigtion if importing data from the web but is this possible using copy/paste ? please help as this is driving me nuts. Im using excel 2007.