AnsweredAssumed Answered

Formatting a Field

Question asked by PaulBurton on Mar 31, 2011
Latest reply on Mar 31, 2011 by ryan


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