Trailing Zeros Disappear in Excel Import
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
Options: Indexed, Can't Modify Auto
Using FM 11