How to save excel columns with long numbers in csv?

The funny thing is, when I want to save excel columns with long numbers as shown below, as a result, csv contains converted numbers to scientific notation, which is unusable. I want them to be saved as text. Any trick for this?

+28160010390002003505456159
12160010390002003505456156
39160010390002003505456155
39160010390002003505456155

thanks

+6
source share
6 answers

To have these 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 when you open the csv file in Excel, you see them truncated and converted to scientific notation.

If so, you need to make an IMPORT csv file. When you do this, the Text Columns wizard opens and allows you to format this column as text. The import location differs in different versions. In Excel 2007, it is on the data tape, Get External Data / From Text.

enter image description here

enter image description here

+3
source

At the end of the number, add a TAB char (ASCII 9).

+13
source

enter the number as a function, as shown below: = "123456789123456789"

+3
source

using openoffice, you can easily save in csv format.

+2
source

This is an old question, but since at the moment it is still the main result of google search in this thread, I think that the stream should be kept up to date. Hussein mahyub gave the only real answer to this question, but has not yet received votes.

The answer that tells us to add a tab character after your number will get a line of text with a tab after it inside excel. It looks visually correct, but it is not correct inside the table. If the goal is to use data in excel as Excel data and use formulas, etc., This can cause problems. Interestingly, if you place a tab in front of the text, it will appear in the data after the text.

An answer that says inserting the word “before the text gets” in the excel file. This is a visually incorrect representation of the data.

The answer, which boasts the virtue of openoffice, is simply an evil troll that doesn't even try to answer the question.

The answer, which explains how to import a CSV that has not been formatted correctly, is good information, but off topic.

Direct answer to the question:

converted to text,largest number ="123456789012",12345678901 
+2
source

Convert a numeric value to text using a text function.

 Text(number,"0") 
0
source

All Articles