[FIXED] How to save excel columns with long numbers into csv?

Issue

Funny thing when I want to save Excel columns with long numbers like below, resulting csv contains converted numbers to scientific notation which is unusable. I want them to be save as text. Any trick to do that?

28160010390002003505456159  
12160010390002003505456156  
39160010390002003505456155  
39160010390002003505456155  

Solution

In order to have those long (>15 digit) numbers in Excel, they are already formatted as text. I suspect that the .csv file also shows them as long numbers (if you open the csv file with Notepad), but that when you open the csv file in Excel, you see them as truncated and converted to scientific notation.

If that is the case, what you need to do is IMPORT the csv file. When you do that, the text-to-columns wizard will open, and allow you to format that column as text. The location of the Import is different in different versions. In Excel 2007, it is on the Data ribbon, Get External Data / From Text.

Answered By - Ron Rosenfeld

Answer Checked By - David Marino (PHPFixing Volunteer)