I have a situation that I hope someone can address...

How do I stop excel from turning my codes into scientific notation? Example - 245E5 when entered into a cell becomes 2.45E+05. I know that you can format the cell as text to avoid this but... when I save the spreadsheet as a CSV file and reopen the file it converts to scientific notation. Is there a setup option that can be set to address this issue? or any other solution

Thank you