Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to save excel columns with long numbers into csv?

Tags:

csv

excel

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  
like image 208
Zulu Z Avatar asked Mar 25 '14 21:03

Zulu Z


2 Answers

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

like image 189
Grzegorz Manda Avatar answered Sep 28 '22 18:09

Grzegorz Manda


put the number as a function like below: ="123456789123456789"

like image 35
Hussein mahyoub Avatar answered Sep 28 '22 16:09

Hussein mahyoub