Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Document Management / March 2008

Tip: Looking for answers? Try searching our database.

Easier way to change decimal and thousand separators

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ElCagle - 15 Mar 2008 00:33 GMT
Am translating a French document into English and having to change tons of
decimal separators (##,##  into ##.##) and thousand separators (## ### ###,##
into  ##,###,###.##).

There has to be an easy way to automate this. My macro knowledge is very
limited, but even with search and replace there has to be an easier way than
1,  2,  3, ... replace 1. 2. 3. ....

Thanks for your help
Jay Freedman - 15 Mar 2008 01:48 GMT
>Am translating a French document into English and having to change tons of
>decimal separators (##,##  into ##.##) and thousand separators (## ### ###,##
[quoted text clipped - 5 lines]
>
>Thanks for your help

You can use wildcard replacement
(http://www.gmayor.com/replace_using_wildcards.htm) to do this more easily.

However, you need to do three replacements in order to get it done correctly.
The problem is that if you immediately change all the comma decimal separators
to periods, there won't be any way to tell them apart from the thousand
separators that are periods; if you change all periods in numbers to commas,
that will catch the decimal separators also.

The solution goes like this:

- First change all comma decimal separators to some character that doesn't occur
between digits anywhere else in the document. Let's assume you can use the tilde
(~) for this. So open the Replace dialog, click the More button, and check the
Use Wildcards option. Put this expression in the Find What box:
   ([0-9]),([0-9])
and put this in the Replace With box:
  \1~\2
Click the Replace All button.

- Next change all the period thousand separators to commas. Use this expression
in the Find What (the same as before except change the comma to a period):
   ([0-9]).([0-9])
and put this in the Replace With box:
  \1,\2
Click the Replace All button.

- Finally, change all the tildes to periods. Use this in the Find What:
   ([0-9])~([0-9])
and put this in the Replace With box:
  \1.\2
Click the Replace All button.

--
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.
Jean-Guy Marcil - 17 Mar 2008 14:17 GMT
> >Am translating a French document into English and having to change tons of
> >decimal separators (##,##  into ##.##) and thousand separators (## ### ###,##
[quoted text clipped - 14 lines]
> separators that are periods; if you change all periods in numbers to commas,
> that will catch the decimal separators also.

Hi Jay,

I am not sure I understand, you write: "there won't be any way to tell them
apart from the thousand separators that are periods". But the thousand
separators in French are spaces, and usually, if the document is done right,
unbreakable spaces.

So, you can easily do this in two pases:

  ([0-9]),([0-9])
  \1.\2

and

  ([0-9])[ ^s]([0-9])
  \1,\2
Jay Freedman - 18 Mar 2008 00:03 GMT
>> >Am translating a French document into English and having to change tons of
>> >decimal separators (##,##  into ##.##) and thousand separators (## ### ###,##
[quoted text clipped - 31 lines]
>   ([0-9])[ ^s]([0-9])
>   \1,\2

Thanks, Jean-Guy. Of course you're correct.

--
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.