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 / July 2006

Tip: Looking for answers? Try searching our database.

Converting the numeric digits to text automatically

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rahul Srivastava - 07 Jul 2006 09:49 GMT
Hi

How can i automatically change the  digits value in text value . Like if a
input is provide in word thru mail merge as Total value 2000$ that i want to
automatically have it coverted in text in another place in the same document
as "Two thousand" dollars.

Kindly help me in providing the answer .
Peter Jamieson - 07 Jul 2006 10:25 GMT
If you have a mergefield called amount containing (say) 2000 you can use

{ MERGEFIELD amount \*cardtext }

to produce

"two thousand"

If amount actually contains "2000$","$2000", "$2,000.00" etc. the result
should be the same, i.e. you need to add the text "dollars" yourself.

For larger numbers cardtext produces what I believe is the American English
version of the number, e.g.

1234 is "one thousand two hundred thirty-four"whereas e.g. in British
English it would typically be "one thousand two hundred and thirty-four"

For really large numbers you might have to do a bit more.

Another switch, \*dollartext, turns 1234.56 into "one thousand two hundred
thirty-four and 56/100"

Peter Jamieson

> Hi
>
[quoted text clipped - 6 lines]
>
> Kindly help me in providing the answer .
 
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.