I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific notation 6.88087E+14. I can revert the number back to its original format by right-clicking the cell > Format Cells > Custom and then selecting 0.
However, I do not want to do this process everytime I open teh CSV file. How can I do this?