I have a lot of cells which I want them to be formatted as texts. However according to Excel they are not texts and hence should be corrected to numbers instead. For example, "6814070833E000101" is a text to me but they gave an error (marked by green tip at the top left hand corner). I tried to click "ignore my error" and converted the file to CSV, but the cells with errors got corrected upon conversion. The mentioned text became "6.81E+110",
I need to have the file in CSV because I would need to use the file for further analysis using a statistical software.
How can I rectify this?