Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
rd
 
Posts: n/a
Default Fromating numbers in Mail merge

Hi,

How do i format numbers that coming from a merged Excel file? i want to have
comma separators, like 10,000.00 instead of 10000.

thanks in advance.

RD


  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor
 
Posts: n/a
Default Fromating numbers in Mail merge

Use a formatting switch on the field thus
{Mergefield Fieldname \# ",0.00"}
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


rd wrote:
Hi,

How do i format numbers that coming from a merged Excel file? i want
to have comma separators, like 10,000.00 instead of 10000.

thanks in advance.

RD



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Cooz
 
Posts: n/a
Default Fromating numbers in Mail merge

Hi rd,

Add the \# switch to your field. For details, check the Word help.

Good luck,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.


"rd" wrote:

Hi,

How do i format numbers that coming from a merged Excel file? i want to have
comma separators, like 10,000.00 instead of 10000.

thanks in advance.

RD



  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
 
Posts: n/a
Default Fromating numbers in Mail merge

See http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"rd" wrote in message
...
Hi,

How do i format numbers that coming from a merged Excel file? i want to

have
comma separators, like 10,000.00 instead of 10000.

thanks in advance.

RD



  #5   Report Post  
Posted to microsoft.public.word.docmanagement
rd
 
Posts: n/a
Default Fromating numbers in Mail merge

WOW, thanks.

RD

"Graham Mayor" wrote in message
...
Use a formatting switch on the field thus
{Mergefield Fieldname \# ",0.00"}
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


rd wrote:
Hi,

How do i format numbers that coming from a merged Excel file? i want
to have comma separators, like 10,000.00 instead of 10000.

thanks in advance.

RD







  #6   Report Post  
Posted to microsoft.public.word.docmanagement
rd
 
Posts: n/a
Default Fromating numbers in Mail merge

Thanks Cooz.

RD

"Cooz" wrote in message
...
Hi rd,

Add the \# switch to your field. For details, check the Word help.

Good luck,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in
via
the Microsoft site, please click Yes to "Did this post answer the
question?".
Thanks.


"rd" wrote:

Hi,

How do i format numbers that coming from a merged Excel file? i want to
have
comma separators, like 10,000.00 instead of 10000.

thanks in advance.

RD





  #7   Report Post  
Posted to microsoft.public.word.docmanagement
rd
 
Posts: n/a
Default Fromating numbers in Mail merge

Thanks Suzanne.

RD


"Suzanne S. Barnhill" wrote in message
...
See http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"rd" wrote in message
...
Hi,

How do i format numbers that coming from a merged Excel file? i want to

have
comma separators, like 10,000.00 instead of 10000.

thanks in advance.

RD





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
page numbers in mail merge Pam Coleman Microsoft Word Help 8 January 30th 06 06:17 PM
Page numbers don't work with mail merge Francisco Mailmerge 3 October 11th 05 06:11 AM
Formating Mail Merge of 10 digit numbers to have parenthasis+dash Omega411 Mailmerge 4 June 20th 05 08:08 AM
Numbers are continuing on every mail merge letter txt box; want 1, kallee Mailmerge 1 May 24th 05 09:05 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM


All times are GMT +1. The time now is 03:55 PM.

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

About Us

"It's about Microsoft Word"