Return to FileMaker.com
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
Filemaker imports data, not formatting. If you want to always display 3 decimal points, change the field type to Number and format it in Filemaker.
Retrieving data ...