1 Reply Latest reply on Jun 20, 2010 9:28 AM by comment_1

    Trailing Zeros Disappear in Excel Import

    brianmacinnes

      Title

      Trailing Zeros Disappear in Excel Import

      Post

      Hi All

       

      First Post. I am importing an Excel file as a recurring import.  A field in the excel file is numeric but has been formatted as text. Any field that has a trailing zero has the trailing zero removed.

       

      Example  128904.110 is imported as 128904.11

       

      The FM Table attributes for the field are

      Type: Text

      Options: Indexed, Can't Modify Auto

       

      Using FM 11

      Excel 2007

      Windows XP