1 Reply Latest reply on Jun 7, 2012 1:54 PM by Sorbsbuster

    How to add a comma for all numbers over 1,000

    RobertMoya

      Title

      How to add a comma for all numbers over 1,000

      Post

      Exactly what the title is saying, im trying to find out how to make a field automaticaly add a comma if the number reaches >1000.

      thanks

        • 1. Re: NoFields
          Sorbsbuster

          Presumably you just want it to display the comma, not actually add a comma?  (Don't think you could, anyway, unless the field is text.)  What version are you using?  In FM11 click on the field, click on the Data Tab of the Inspector Palette and down at the bottom tick 'Show thousands separator'.