Microsoft Excel will automatically convert data columns into the format that it thinks is best when opening comma-separated data files. Microsoft Excel bo samodejno pretvori stolpce s podatki v formatu, da misli, da je najbolje, ko odprete z vejico ločene podatkovne datoteke. For those of us that don't want our data changed, we can change that behavior. Za tiste od nas, ki ne želijo naši podatki spremenili, lahko spremenite to vedenje.

You have a CSV file probably exported from other application or given to you by other people. Imate CSV datoteko verjetno izvažajo iz druge aplikacije ali ki vam ga drugi ljudje. You would like to open it up in Excel since you know it very well. Želeli bi, da ga odprete v Excelu, saj veste, da je zelo dobro. The CSV file will look like this (if you open the file in notepad.exe): Datoteka CSV bo videti takole (če odprete datoteko v notepad.exe):

The file contains columns: ProductModelID, Name, SpecialID, and ModifiedDate. Datoteka vsebuje stolpce: ProductModelID, Name, SpecialID, in ModifiedDate. The column SpeicalID containing data with leading 0 and it is specialized code so you would like to keep the leading 0s in Excel. Stolpec SpeicalID, ki vsebujejo podatke z vodilnimi 0 in je specializirano kodo, da bi želeli obdržati vodilno 0. v Excelu. Since it is a CSV file it is, by default, shown in your Windows Explorer as an Excel file: Ker je CSV datoteka je, privzeto, prikazane v vaš okno raziskovalec kot datoteko Excel:

So you double-click the file and open the file in Excel as such: Torej dvokliknete datoteko in odprite datoteko v Excelu kot tak:

You can see that by default, Excel stripped out the leading 0s in column 3 “SpecialID €?. Vidite lahko, da je privzeto, Excel izloča iz vodilne 0. v stolpcu 3 "SpecialID €?. You brought up Excel application and tried to use File/Open to open the file manually and that doesn't work either. Ti dvignejo Excel uporabe in preizkušen za uporabo Datoteka / Odpri, da odprete datoteko ročno in da ne dela niti. How can I fix this? Kako lahko to popravimo?

The trick is to rename the file with .TXT extension then bring the file into Excel. Trik je v preimenovati pila s. Razširitvijo TXT potem bi v datoteko Excel. SO first bring up “My Computer €? SO prvi bruhati "My Computer €? and navigate the folder to where the file resides. ter pluti mapo za datoteke, kjer prebiva.

Now, if you don't see the file extension .CSV (Windows has this option disabled by default) then follow this step to enable the file extension – Select the menu “Tools €?/ €?Folder Options €? Zdaj pa, če ne vidite datoteke. CSV (Windows je ta možnost privzeto onemogočena), sledite tem korakom, da bi pila razsežnost - Izberite meni "Tools €? / €? Možnosti mape €? then select the “View €? torej izbrati "View €? tab, uncheck the item “Hide extensions for known file types €? kartici, nenadzirljiv postavko "Skrij pripone za znane vrste datotek €? as the picture below: kot je slika spodaj:

Then you should see the file extension as such: Potem bi morali videti pripono kot tak:

Right click the file and select rename to rename the file to become “ProductInfo.txt €? Z desno tipko kliknite datoteko in izberite preimenovati v preimenovati datoteko, da postane "ProductInfo.txt €?

Notice the icon changes to regular text file icon as well. Obvestilo ikona spremeni v rednih text file icon enako. No open up Excel and use “File €?/ €?Open €? No odpreti Excel in uporaba "File €? / €? Open €? command to bring the file into Excel. ukaz, da bi v datoteko Excel. When you do this, a dialog will pop up like: Ko to storite, se bo pogovorno okno pop up, kot so:

Make sure the “Delimited €? Poskrbite, da "Delimited €? radio button is selected and click on “Next €? izbirni gumb je izbran, in kliknite na "Naprej €? button to continue. gumb za nadaljevanje. On the next screen, check the box “Comma €? Na naslednjem zaslonu, preverite polje "Comma €? and uncheck all other selections. ter počistite vse druge izbire.

Click on “Next €? Kliknite na "Next €? to advance to the next screen. napredovati v naslednjem zaslonu. In this screen, you need to click on the “SpecialID €? V tem zaslonu, morate klikniti na "SpecialID €? column and select the “Text €? stolpec in izberite "Text €? radiobutton from the “Column data format €? RadioButton iz "podatki stolpec format €? section. oddelek.

Click on “Finish €? Kliknite na "Finish €? then you are done. potem ste končali.

You can see now the column “SpecialID €? Ogledate si lahko zdaj stolpcu "SpecialID €? has been brought in as a Text column and all leading 0 are preserved. je bila vložena kot v stolpcu Besedilo in vse vodilne 0 so ohranjeni.

This method can be applied to any special circumstance for bringing in a CSV file into Excel including other delimited files. Ta metoda se lahko uporablja za vse posebne okoliščine za vložitev v datoteko CSV v Excel datotek, vključno z drugimi razmeji. With the ability of specifying the data type for each column during the data importing process you are in much better control on your final result. S sposobnost navedbo vrste podatkov za vsak stolpec v podatke uvoznice proces ste v veliko boljši nadzor na vaš končni rezultat.