Post reply

Mass changes to numeric fields

  • December 20, 2013 at 3:43 pm

    #302573

    I have multiple numeric fields that are decimals. I need to change the output to currency, right align the data and put the dollar amounts on the bottom. At best this is tedious since I have to do 20 fields exactly the same. Right now I open each field and make the changes. Is there a way to make mass changes to the data that uses the same formats?

    Thanks

  • December 27, 2013 at 6:51 am

    #1676065

    You can just click to select the fields (press and hold Crtl to select multiple fields) and then change these properties in the properties sidebar (press F4 to make this appear).

    You can then enter the text for the currency format in the Format property , it would be something like

    '$'0.00;('$'0.00)

    The TextAlign property can be used to adjust the alignment etc.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply