Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dimitri Dimitri is offline
external usenet poster
 
Posts: 5
Default 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   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

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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dimitri Dimitri is offline
external usenet poster
 
Posts: 5
Default 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   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.



.



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dimitri Dimitri is offline
external usenet poster
 
Posts: 5
Default 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.


.



.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge formatting [email protected] Microsoft Word Help 5 February 26th 07 11:07 AM
Formatting in Mail Merge Michael Cullis Mailmerge 4 October 5th 06 08:47 PM
Formatting in Mail Merge Michael Cullis Mailmerge 0 October 3rd 06 07:45 AM
Mail Merge Formatting lpriest Mailmerge 1 June 16th 06 06:14 PM
Mail Merge fields merge with different formatting KP Microsoft Word Help 1 February 22nd 06 12:01 PM


All times are GMT +1. The time now is 06:36 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"