#1
|
|||
|
|||
Number to word in word 2007
Hi
I am just entering in to this forum, and I am learning word macro through this forum. I would like to use a mail merged document containing data from excel I would like to use number to word for ceratin portion of document Prefixed with " Rupees" and spell the number to text for thouse portions can you please as to how to go about this. Thanks & Regars N.Srinivasan |
#2
|
||||
|
||||
In that case, you don't need a macro - you need to use the appropriate field coding & field switches. For example:
Rupees { MERGEFIELD Value \* CardText \* Caps} where 'Value' is the name of the field in your data source and the braces (i.e. {}) are created in the document via Alt-F9.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi
Thanks a lot When it is giving a huge gap beween two words it is appearing one thousand for 1000. I would like to start the word with " Rupees" for each and every figure and within the bracket Rs.1000 (Rupees One thousand Only) can you please help Regards N.Srinivasan |
#4
|
||||
|
||||
If you want parentheses around 'Rupees ' and the mergefield, with ' only' before the closing bracket, then add the text to your mailmerge main document - this is basic text entry and has nothing to do with mailmerge. I have no idea what you mean about a 'huge gap' - there is only a single space between each word pair.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to find number of coma and then add that number of rows in word using macro? | PRA007 | Word VBA | 7 | 05-27-2015 10:45 PM |
Number from Barcode and MS Word - formatting number | svuotapista | Word | 5 | 01-30-2015 02:34 AM |
Chapter Number Became a Problem for me in MS Word 2007 | srinivas2036 | Word | 1 | 09-24-2013 12:23 PM |
How To Show Number of Pages in Word 2007 | CGM3 | Word | 2 | 07-21-2013 08:17 PM |
Word 2007 TOC Section Number w/Alpha Prefix? | Gwen Butler | Office | 2 | 09-29-2011 06:10 AM |