5 Replies Latest reply on Apr 21, 2016 2:54 AM by Obi-wan Kenobi

    GREP for changing thousands separator in numbers

    Fourteen Level 2

      I've been trying to find a simple way to do the following which some of you may have already resolved and could lend a hand.

       

      I'm looking to change the formatting for large numbers from a European format: 1 000 000 to the basic 1,000,000 format. Basically I just need to strip out the spaces and then replace them with commas in the appropriate positions without removing spaces that precede the numbers themselves.

       

      Thanks for any help with this! I'm still learning this whole GREP thing.