Formatting a Field
Using a script, I populated a table from another table. I inserted data into the fields of a column named "Key." The data in the source table is of type Number. The source data has no decimal and no trailing 0s. When I populated the table, the data inserted has a decimal and 4 trailing zeros. How do I get rid of the zeros?
What's weird is that the script I used is a copy of a script I used to do the same exact thing on another table. The other table was populated with no decimal and no trailing zeros. Odd. . . .
Dos the ".0000" appear in other layouts with that field in the destination table?
If not, then it sounds like a simple formatting issue with that field in your layout. In laymout mode, "turn off" the decimal point and the trailing zeros by formatting that field to your liking.