Post your ideas, questions, or feedback.

Prevent Excel Drop Leading Zeroes in CSV Item Number Field

When I export Elliott's Item Number to CSV through either Export Processor, or Elliott provided reports with CSV export option, the leading zeroes will be dropped when I open it with Excel. For example, item number 0100, when open the CSV in Excel, it is displayed as 100. I found the following article that can address this issue:

https://superuser.com/questions/330291/how-to-stop-excel-from-auto-formatting-and-making-it-work-like-a-number-crunchin

This article suggest instead of exporting item number 0100 in the CSV as "0100", we can add a equal sign "=" in the front to make it ="0100", this way, Excel will preserve the leading zero.

6 votes
Sign in
Signed in as (Sign out)

We’ll send you updates on this idea

AdminEdward M. Kwang - NETcellent System, Inc. (Admin, NETcellent Systems, Inc.) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

This has been addressed for the following fields – item number, 25 character PO number, tracking number, and UPC codes. The change will be available in the next Elliott release. For further information on this change, refer to http://support.elliott.com/knowledgebase/articles/1832839-feature-prevent-excel-drop-leading-zeroes-in-csv concerning the changes for Elliott reports with CSV support and http://support.elliott.com/knowledgebase/articles/1833061-feature-equal-sign-support-in-export-processor concerning changes to the V8.2 Export Processor.

3 comments

Sign in
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base