changing decimal commas to periods and vice versa

A

Alan

I need to change several hundred figures like 12.345 to 12,345, and 12,3% to
12.3%.
In the past (Word 2003), I've done this using wildcards, with the following
find and search strings:
([0-9])([0-9])([0-9]).([0-9])([0-9])
\1\2\3.\4\5
However, in 2007, I'm getting:
12345,
and
123%,
FWIW, I've also tried using the "beginning of word" and "end of word"
parameters, but to no avail.
Could someone please tell me what I'm doing wrong?
Thanks,
 
J

Jay Freedman

I need to change several hundred figures like 12.345 to 12,345, and 12,3% to
12.3%.
In the past (Word 2003), I've done this using wildcards, with the following
find and search strings:
([0-9])([0-9])([0-9]).([0-9])([0-9])
\1\2\3.\4\5
However, in 2007, I'm getting:
12345,
and
123%,
FWIW, I've also tried using the "beginning of word" and "end of word"
parameters, but to no avail.
Could someone please tell me what I'm doing wrong?
Thanks,

Assuming that you actually had a comma in the search expression rather than the
period you showed, that should work -- and on my computer it does work
correctly.

Try a variation: search for

([0-9]@),([0-9]@)

and replace with

\1.\2

That should change all numbers that have one or more digits on both sides of the
comma.

One other thought: I do vaguely recall some bug having to do with the order of
replacements, but I'm not seeing it now. If you haven't yet installed Office
2007 SP1, visit the Microsoft Update site and get it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top