Formating fields in mail merge

[Tamir]

Hi,
When doing a mail merge (using excel 2003 as my data base) I lose the comma
of the thousands. How can I format the mail merge field? Are there formating
switches?
Thank you,
Tamir

 

[macropod]

Hi Tamir,

To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# "$,0.00;($,0.00);") zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.

 

[Tamir]

Thank you,
Works like a charm
Tamir

Hi Tamir,

To control number & currency formatting in Word, add a numeric picture
switch to the mergefield. To do this:
. select the field;
. press Shift-F9 to reveal the field coding. It should look something like
{MERGEFIELD MyData};
. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or
whatever other numeric format you prefer - see below);
. position the cursor anywhere in this field and press F9 to update it;
. run your mailmerge.

Note: The '\# $,0.00' in the field is referred to as a numeric picture
switch. Other possibilities include:
. \# 0 for rounded whole numbers
. \# ,0 for rounded whole numbers with a thousands separator
. \# ,0.00 for numbers accurate to two decimal places, with a thousands
separator
. \# $,0 for rounded whole dollars with a thousands separator
. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative
numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can
use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following,
(eg \# "$,0.00;($,0.00);") zero values will be suppressed. Note that this
suppresses 0s resulting from empty fields and from fields containing 0s.

--
Cheers
macropod
[Microsoft MVP - Word]

Hi,
When doing a mail merge (using excel 2003 as my data base) I lose the
comma of the thousands. How can I format the mail merge field? Are there
formating switches?
Thank you,
Tamir

 

[מיכ×ל (מיקי) ×בידן]

עפ"×™ שמך ×× ×™ מרשה לעצמי לצ×ת מנק' ×”× ×—×” ש×תה ×§×•×¨× ×’× ×¢×‘×¨×™×ª - ולכן ×עצתי לך
לבדוק דרך נוספת, שלדעתי, ×”×™× ×” פשוטה מ×ד:
בגיליון ×”'×קסל' - לצד ×”× ×ª×•× ×™× ×”×ž×¡×¤×¨×™×™× - פתח עמודת עזר והצג בה ×ת המספרי×
בעזרת הפונקציה: FIXED ×ו: TAXT.
× × ×™×— ×©×‘×ª× A1 הקלדת: 123,456,789.45
×‘×ª× B1 הקלד: (2,Fixed(A1= [×”-2 מציין 2 ספרות עשרוניות]
×ו:
("##.#,#",Text(A1=
כעת - כל שנותר לך ×”×•× ×œ×”×¤× ×•×ª ×ת המיזוג לת××™× ×לה.
והמשך/×™, × ×, ×œ×§×¨×•× ×ת השורה הב××”:
***********
×× ×ª×’×•×‘×ª×™ עזרה לחץ/×™, × ×, על <כן> בפס ×”×ופקי התחתון!
***********
מיכ×ל ×בידן
מנהל ×¤×•×¨×•× "×ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"Tamir":

Thank you,
Works like a charm
Tamir

Hi Tamir,

To control number & currency formatting in Word, add a numeric picture
switch to the mergefield. To do this:
. select the field;
. press Shift-F9 to reveal the field coding. It should look something like
{MERGEFIELD MyData};
. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or
whatever other numeric format you prefer - see below);
. position the cursor anywhere in this field and press F9 to update it;
. run your mailmerge.

Note: The '\# $,0.00' in the field is referred to as a numeric picture
switch. Other possibilities include:
. \# 0 for rounded whole numbers
. \# ,0 for rounded whole numbers with a thousands separator
. \# ,0.00 for numbers accurate to two decimal places, with a thousands
separator
. \# $,0 for rounded whole dollars with a thousands separator
. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative
numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can
use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following,
(eg \# "$,0.00;($,0.00);") zero values will be suppressed. Note that this
suppresses 0s resulting from empty fields and from fields containing 0s.

--
Cheers
macropod
[Microsoft MVP - Word]

Hi,
When doing a mail merge (using excel 2003 as my data base) I lose the
comma of the thousands. How can I format the mail merge field? Are there
formating switches?
Thank you,
Tamir

.

 

[dhaval]

Hi,
When doing a mail merge (using excel 2003 as my data base) I lose th
comma
of the thousands. How can I format the mail merge field? Are ther
formating
switches?
Thank you,
Tamir

First you select all data than press shift plus f9 and select you ge
mail merge put a mouse cursor on data in press f9 and run mail merg
you got your answer

 

[macropod]

Hi dhaval,

I don't think so. How is that supposed to correct the formatting?