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:

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 Sign in with NETcellent Systems, Inc.
Signed in as (Sign out)

We’ll send you updates on this idea

AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, 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 concerning the changes for Elliott reports with CSV support and concerning changes to the V8.2 Export Processor.


Sign in Sign in with NETcellent Systems, Inc.
Signed in as (Sign out)

Feedback and Knowledge Base