I have imported a text file to excel. The file has numeric and text columns. In the numeric column there are some scientific numbers which are only in text format. When I import the excel file to matlab I face with a problem about the scientific numbers which says these are not number! How can I deal with these numbers? Why that has been arised?
The file was at the beginning a result of one sequencing program. Then I added txt suffix to change it into a text format. And finally I opened it in Microsoft excel and saved as xlsx format. Here is how one row of my file looks like in excel sheet:
ENSMUSG00000078645 - - ENSMUSG00000078645 Fam63a TSS68162 3:95085766-95088779 - - **6.41727e-317** 0 0.309616 OK
the bold number is one of those scientific numbers.
Here is some part of original text file:
tracking_id class_code nearest_ref_id gene_id gene_short_name tss_id locus length coverage FPKM FPKM_conf_lo FPKM_conf_hi FPKM_status ENSMUSG00000088390 - - ENSMUSG00000088390 U7 TSS3702 1:3668960-3669024 - - 0 0 0 OK