3 Replies Latest reply on Aug 10, 2015 10:36 AM by go2qdesign

    grep for changing minus sign to parenthesis

    go2qdesign Level 1

      I do a lot of tables that come from differing spreadsheet data that shows negative numbers with either minus sign or inside parentheses. For the sake of consistency I'd like to be able to change the minus signs to parentheses. Any chance this is something that could be done with GREP?

       

      as an example:

      taking this - -

      -123.00

      -345.00

      678.00

      -910.11

      and turning it into this:

      (123.00)

      (345.00)

      678.00

      (910.11)