How to save excel columns with long numbers into csv?

Question

Welcome To Ask or Share your Answers For Others

How to save excel columns with long numbers into csv?

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

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

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

320 views

1 Answer

深蓝 · Answer 1 · 2021-10-17T00:48:39+0000

answered Oct 17, 2021 by 深蓝 (71.8m points)

Append a TAB char (ASCII 9) at the end of a number.

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

Categories

How to save excel columns with long numbers into csv?

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Just Browsing Browsing

Most popular tags