1 Reply Latest reply on Mar 31, 2011 5:52 AM by ryan

    Formatting a Field



      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. . . .

        • 1. Re: Formatting a Field

          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.