Find and Replace - A bit more complicated

H

Helen

Hello,

I tried finding a solution by myself, but no-can-do. How can I tell Word to:

a) Find the dollar sign ($) and;
b) Place it at the end of the amount instead of the beginning, i.e., change
$10,000 for 10 000 $.

It also has to be preceded by a hard space.

Thank you!

Hélène
 
H

Helmut Weber

Hi Helen,

how regular are the amounts?
lowest ? 0.5 ?
highest ?
e.g. 10,000,333,444,555
Decimal fractions?
It also has to be preceded by a hard space.
A hard space before dollar sign, right?

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
 
H

Helen

Hi Helmut,

The amounts could be different but mostly as follows:

$10,000.88 -- $1,234.88 -- $123,898,999.00

There would be decimal fractions and they too will have to be changed. For
example, the decimal separator will now become a comma instead of a period.

It is a case of converting English amounts into French amounts.

Thanks.

Hélène
 
H

Helmut Weber

Hi Helen,

you need to know quite a bit about macros.

If so then
may I suggest to ask again in
microsoft.public.word.vba.general

There are more people enjoying questions like that.

I'm thinking about a programmatic solution,
but in case you've never used a macro,
it would be very hard.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
 
H

Helen

Helmut,

I appreciate you taking the time to make this suggestion and I will most
certainly follow it.

Thank you! And greetings from Montreal, Canada!
 

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