Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
page numbers in mail merge | Microsoft Word Help | |||
Page numbers don't work with mail merge | Mailmerge | |||
Formating Mail Merge of 10 digit numbers to have parenthasis+dash | Mailmerge | |||
Numbers are continuing on every mail merge letter txt box; want 1, | Mailmerge | |||
mail merge with attachments | Mailmerge |