AnsweredAssumed Answered

Trailing Zeros Disappear in Excel Import

Question asked by brianmacinnes on Jun 20, 2010
Latest reply on Jun 20, 2010 by comment_1

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

 

 

Outcomes