Scientific Notation and .CSV

**thehotcorner** · 07-22-2008, 01:19 PM

Here's my problem, I have an excel file with a column of 12 digit numbers. I need to save this file as a comma separated text file with the formatted normally (not in scientific notation).

My usual process is to save it as a .csv then change the extension to .txt but excel automatically puts the numbers into scientific notation as soon as I save it as a .csv 453139201.3949E+11, etc. and in the process I lose the last couple digits of the number.

In short I need to take a normal .xls file with 12 digit numbers and turn it into a comma separated txt file that is not in scientific notation.

**NBVC** · 07-22-2008, 01:33 PM

Try converting the numbers to text first...

Select the column and go to Data|Text to Columns... skip to the 3rd dialogue window and select Text in the Column Data Format area.... click Finish.

**adompe3** · 11-01-2018, 12:47 PM

I have a similar 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 CVS file and reopen the file it converts to scientific notation.

Thank you

**MrShorty** · 11-01-2018, 01:02 PM

@adompe3: This forum is rather strict about rules like not posting your question in the (old) thread of another member. The forum prefers that you start your own thread -- adding a link or reference to this thread if it will help explain the question you wish to discuss.