Remove . (period) from merged data

C

CW

I have a Word 2003 doc that merges data from our database, including a ref no
which contains a period as part of its format (e.g. 10.001).
We now need to remove the period from the ref no once merged in the Word
doc, as another company who receive the document (shipping company) are
having problems with it. They need it to be shown as 10001.
We cannot/do not want to re-format the ref no in the database itself, as it
serves a useful purpose for us.
Is there a way to "code out" the period once the ref has arrived in the Word
doc, perhaps by using a numeric picture switch or some such method?
Many thanks
CW
 
G

Graham Mayor

A calculated field *may* work. Try

{ ={Mergefield REFNO } * 1000 }

Where REFNO is your reference number field and the brackets are all inserted
with CTRL+F9.
This assumes that all the numbers equate to three places of decimals.

Let us know whether that works before suggesting anything more complicated.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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