hi solus
have eventually solved this myself was all to do with the formatting of the cells on the spreadsheet , changed format to text and hey it worked
many thanks for looking