2 Replies Latest reply on Aug 26, 2009 4:00 PM by dysartj

    Leading zeros missing when importing from .xlsx file.



      Leading zeros missing when importing from .xlsx file.




      I have noted several posts about this issue, but have not found a solution, only workarounds. The identical file in .xls format has worked flawlessly.


      Here are the parameters of my project:

      1. Excel (.xlsx) cells are formatted as text.

      2. FmPro 10.0.3 receiving fields are text

      3. The original data is in delimited text form using a semi-colon as the separator, so is imported to Excel to make it available for FMPro and to set text options.


      This obviously is due to a difference in how FMPro interacts with .xlsx versus .xls.


      Is this issue currently being tested?


      I have several situations and numerous scripts where these leading zeros are important. It would be helpful if I didn't have to go through my databases to compensate for this.


      thanks for any guidance you may have.