4 Replies Latest reply on Jun 26, 2008 6:03 AM by (Sabian_Zildjian)

    % formating if a whole number is inputted

    Level 1
      Hello:

      I have a numeric field on my form. I clicked on the field, went to the "Cell" tab clicked on "Patterns" and in the "Display" tab set my pattern to " num.percent{} "

      My problem is that my user wants it to display 10% when they key in "10" (whole number) currently keying in "10" displays 1,000%.

      So far the only way to display 10% is by keying in ".10". I understand why .10 gives me 10% but the behavior of the users will be to key in a whole number.

      What is the best way to solve?

      Thanks,

      Keith.