View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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.



.