|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 5th, 2010, 02:17 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge & Formatting
Is there a way to format numbers using mail merge.
Needs to lead with $. Has to have a comma to indentify in the thounsands. Can only have two digits after the decimal place. Note: the merge list was created using vlookup. 
|
|
#2
February 5th, 2010, 02:20 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge & Formatting
See http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Dimitri" wrote in message ... Is there a way to format numbers using mail merge. Needs to lead with $. Has to have a comma to indentify in the thounsands. Can only have two digits after the decimal place. Note: the merge list was created using vlookup.
|
|
#3
February 5th, 2010, 03:09 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge & Formatting
Graham:
Your website is great but one question. Once the I put the merge field how do you get the formula to convert the data. Thanks Dimitri "Graham Mayor" wrote: See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Dimitri" wrote in message ... Is there a way to format numbers using mail merge. Needs to lead with $. Has to have a comma to indentify in the thounsands. Can only have two digits after the decimal place. Note: the merge list was created using vlookup. .
|
|
#4
February 5th, 2010, 03:31 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge & Formatting
I am not sure what you mean. If you insert a mergefield from the toolbar you
will get something like Fieldname If you toggle the field codes (ALT+F9) you will see {Mergefield Fieldname} Insert the switch before the final bracket {Mergefield Fieldname \# "$,0.00"} then update the field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Dimitri" wrote in message ... Graham: Your website is great but one question. Once the I put the merge field how do you get the formula to convert the data. Thanks Dimitri "Graham Mayor" wrote: See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Dimitri" wrote in message ... Is there a way to format numbers using mail merge. Needs to lead with $. Has to have a comma to indentify in the thounsands. Can only have two digits after the decimal place. Note: the merge list was created using vlookup. .
|
|
#5
February 5th, 2010, 04:58 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge & Formatting
The formatting is applied when something updates the field, which should
happen when you a. select it and press F9 or b. when you use mail merge preview and move to another record or c. when you merge Peter Jamieson http://tips.pjmsn.me.uk On 05/02/2010 15:09, Dimitri wrote: Graham: Your website is great but one question. Once the I put the merge field how do you get the formula to convert the data. Thanks Dimitri "Graham Mayor" wrote: See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org wrote in message ... Is there a way to format numbers using mail merge. Needs to lead with $. Has to have a comma to indentify in the thounsands. Can only have two digits after the decimal place. Note: the merge list was created using vlookup. .
|
|
#6
February 5th, 2010, 07:21 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge & Formatting
Your title should be GOD not MVP = )
Works amazing Dimitri "Graham Mayor" wrote: I am not sure what you mean. If you insert a mergefield from the toolbar you will get something like Fieldname If you toggle the field codes (ALT+F9) you will see {Mergefield Fieldname} Insert the switch before the final bracket {Mergefield Fieldname \# "$,0.00"} then update the field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Dimitri" wrote in message ... Graham: Your website is great but one question. Once the I put the merge field how do you get the formula to convert the data. Thanks Dimitri "Graham Mayor" wrote: See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Dimitri" wrote in message ... Is there a way to format numbers using mail merge. Needs to lead with $. Has to have a comma to indentify in the thounsands. Can only have two digits after the decimal place. Note: the merge list was created using vlookup. . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
