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 / Mailmerge and Fax / December 2005

Tip: Looking for answers? Try searching our database.

Converting Numerals to Words in Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
a_ryan1972 - 07 Dec 2005 18:31 GMT
I have a merge document.  Field one is amounts in numerals.  Field two is the
same amount, but it is written out in words.  Is there any way to
automatically fill in field2 based on field one?

Thanks.
Doug Robbins - Word MVP - 07 Dec 2005 22:18 GMT
Add a \* cardtext switch to the field.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a merge document.  Field one is amounts in numerals.  Field two is
>the
> same amount, but it is written out in words.  Is there any way to
> automatically fill in field2 based on field one?
>
> Thanks.
a_ryan1972 - 08 Dec 2005 13:15 GMT
I tried that and it rounds up to the nearest whole number.  What I forgot to
mention is that my amounts are in dollars and cents.  So I would like to
insert $32.50 into field one and have field 2 automatically say Thirty-Two
Dollars and 50 cents.

Thank you.

> Add a \* cardtext switch to the field.
>
[quoted text clipped - 4 lines]
> >
> > Thanks.
a_ryan1972 - 08 Dec 2005 16:01 GMT
I got it.  Thank you.

> I tried that and it rounds up to the nearest whole number.  What I forgot to
> mention is that my amounts are in dollars and cents.  So I would like to
[quoted text clipped - 11 lines]
> > >
> > > Thanks.
 
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.