mardi 31 mai 2016

Stupid .CSV files and Excel

Every time I go into a .CSV using Excel, it drops the leading zero on the zip code.

Right click, format text, special, zip code. blah blah

I'll save it, but if I have to go back into the .csv file for some reason, that formatting doesn't stay. I have to reformat those columns.

Any way to stop this? Have excel save the format?


via International Skeptics Forum http://ift.tt/1r1urHg

Aucun commentaire:

Enregistrer un commentaire