Scientific Cell Fomat to Text

Hi,
i have a csv file from which i am downloading data into my excel file. for some reason one of the columns in the csv file gets converted o scientific formats and gets downloaded into my excel file also in that format. i want this to get converted in text format thru a macro can anybody give me some idea. any help will sincerely be appreciated.

thanks