Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Alan Alan is offline
external usenet poster
 
Posts: 65
Default changing decimal commas to periods and vice versa

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,

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default changing decimal commas to periods and vice versa

On Tue, 29 Apr 2008 14:37:01 -0700, Alan wrote:

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.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to convert word to excel and vice versa antares Microsoft Word Help 3 March 15th 08 08:22 PM
Convert Text to Numbers and Vice Versa RPMitchal Microsoft Word Help 10 November 23rd 07 03:16 PM
spaces after commas and periods rehklh Microsoft Word Help 3 November 25th 06 10:36 PM
Create multiple documents from one and vice versa Village Idiot Dan Microsoft Word Help 7 October 24th 05 02:27 PM
How do I make my third page my last and vice versa? confused Microsoft Word Help 1 December 27th 04 06:53 PM


All times are GMT +1. The time now is 07:52 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"