I downloaded an excel CSV file and the dates apeared as 2.01402E+16. I tried formatting it to number but got 20140221000000000. Can someone please assist inremoving the zeros at the end to make it 20140221?

Many thanks.