Yesterday I was faced with the challenge of adding a dollar sign to all the number amounts in several columns of a several-page-long table. First, I figured out how to use wild cards to do it for any number of 2 or 3 places. (All numbers had 2 digital places, but this seemed irrelevant to me purpose.) However, while perhaps a dozen of the numbers were only three places, e.g., 306.54, most of them were in the thousands or ten-thousands, with a comma. I found that my search formula then jumped to the hundreds places, e.g., 13,576. Then I determined how to change the search to look for these larger numbers, following my first parenthesized term with a comma and then using a second parenthesized term with {3}, but then it would not work for those only in the hundreds.



Is there a way, using wildcards, to find both in a single search?

Find
<([0-9,]{1,}).([0-9]{2})

Replace
$\1.\2

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thank you, sir!