9

Prevent Excel from formatting my cells

view full story
linux-howto

http://superuser.com – I want to import a CSV file into Excel. One of the columns has a bunch of codes such as: 13AV1250 340101000825 531 0849 10 No matter what I do, codes like 340101000825 always end up showing up like 3.40101E+11. Is there anything I can do about this other than manually fixing each value? If I click the column and format as text, it'll stay the same unless I manually double click each cell. This is how one of my rows in my CSV file looks if you open it with Notepad: "340101000825","-","Unknown" (HowTos)