{"id":3172,"date":"2014-12-18T17:59:30","date_gmt":"2014-12-18T22:59:30","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3172\/when-i-export-data-from-inflow-the-leading-zeroes-are-getting-lost-help\/"},"modified":"2018-05-11T12:39:23","modified_gmt":"2018-05-11T16:39:23","slug":"when-i-export-data-from-inflow-the-leading-zeroes-are-getting-lost-help","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/60916240\/when-i-export-data-from-inflow-the-leading-zeroes-are-getting-lost-help\/","title":{"rendered":"When I export data from inFlow On-Premise, the leading zeroes are getting lost. Help!"},"content":{"rendered":"

For example, you might have a Product named \u201c007\u201d in your product list. At some point you may have clicked\u00a0Main Menu > General > Export Data<\/em> to save your products to a CSV file. Then when you open the CSV file in Excel, you see it just showing up as \u201c7\u201d and wonder if there is some secret agent modifying your products.<\/p>\n

Actually, what\u2019s going on here is that inFlow On-Premise is correctly exporting \u201c007\u201d (you can check this by opening the .CSV file in a text editor like Notepad), but Excel interprets this as a number, and simplifies the display by showing it just as \u201c7\u201d.<\/p>\n

There are two workarounds, shown below:<\/p>\n\n

Modify your data so that Excel can\u2019t interpret it as a number<\/h2>\n

If instead of naming your product 007, you named it 007* or 007-BOND, Excel wouldn\u2019t be able to misinterpret it as a number to be simplified, and this would get around the issue.<\/p>\n

Of course, this would require that you rename things in inFlow, and this isn\u2019t possible in some cases, most notably for barcodes that start with 0.<\/p>\n\n

Use Excel\u2019s Data Import Wizard<\/h2>\n

Instead of opening the CSV file just by double-clicking on it, you can use another method in Excel. (Instructions for Excel 2013)<\/p>\n

    \n
  1. Open a new empty document in Excel.<\/li>\n
  2. Go to the Data<\/em> tab, then click Get External Data > From Text<\/em>.
    \"\"<\/div><\/li>\n
  3. Select your CSV file.<\/li>\n
  4. Excel\u2019s Text Import Wizard<\/em> should show up. Select the file type Delimited<\/em>, and click Next<\/em>.<\/li>\n
  5. Check the Tab\u00a0<\/em>and\u00a0Comma<\/em> box under Delimiters, and under Text<\/em> qualifier, select the (double) quotation mark. Click Next<\/em>.
    \"60916240_2\"<\/div><\/li>\n
  6. Click on each column that you\u2019re having a problem with, then set the Column data format to Text.
    \"60916240_3\"<\/div><\/li>\n
  7. Click Finish. When Excel asks you where to put the data, you can insert it into the Existing worksheet.<\/li>\n<\/ol>\n\n\n","protected":false},"excerpt":{"rendered":"

    For example, you might have a Product named \u201c007\u201d in your product list. At some point you may have clicked\u00a0Main Menu > General > Export Data to save your products to a CSV file. Then when you open the CSV file in Excel, you see it just showing up as \u201c7\u201d and wonder if there […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":""},"categories":[20,23],"tags":[46,49],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3172"}],"collection":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=3172"}],"version-history":[{"count":9,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3172\/revisions"}],"predecessor-version":[{"id":25324,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3172\/revisions\/25324"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}