Hi, i really dont know what to do. I am stuck on filtered vcf data into [using excel 2016]. Unfortunately it was filtered by somebody else so i dont have original vcf file.
I noticed that in vcf data the decimal numbers have dot insted comma. This changed some values like CADD_phred or QUAL into date [format on picture].
Sadly i need to filter my data according QUAL & CADD_phred columns. Is it possible to changed back that data into numeric value without changing cells value?
Even Though my advisor told me that they don't care about it, I am really worried. I got 78 thousands rows of variables but 10 % of it is this badly formated data. So i dont think that my analysis wouldnt be biased if i delete that part.
[literally any help is welcome]
I thought it was silly. Yet now I am extremely frightened to take the next step.