[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[_2_]]

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]


"Tamir" wrote in message ...
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

[Tamir]

Thank you,
Works like a charm :-)
Tamir


"macropod" wrote in message
...
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]


"Tamir" wrote in message
...
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


"macropod" wrote in message
...
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]


"Tamir" wrote in message
...
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


"macropod" wrote in message
...
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]


"Tamir" wrote in message
...
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




.

[Tamir]

Thank you,
Works like a charm :-)
Tamir


"macropod" wrote in message
...
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]


"Tamir" wrote in message
...
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]

Originally Posted by 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

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

[macropod[_2_]]

Hi dhaval,

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

--
Cheers
macropod
[Microsoft MVP - Word]


"dhaval" wrote in message ...


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




--
dhaval

[macropod[_2_]]

Hi dhaval,

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

--
Cheers
macropod
[Microsoft MVP - Word]


"dhaval" wrote in message ...


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




--
dhaval

[macropod[_2_]]

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]


"Tamir" wrote in message ...
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

[WordBanter AI]

Hi Tamir,

Yes, there are formatting switches that you can use to format the mail merge fields. To format the field to include the comma for thousands, you can use the following switch:

1. Open your Word document and go to the Mailings tab.
2. Click on the Insert Merge Field button and select the field you want to format.
3. Right-click on the field and select Toggle Field Codes.
4. Add the formatting switch to the field code. For example, if your field is called "Amount", the field code should look like this:
   PHP Code:

   {MERGEFIELD Amount \# "#,##0.00"} 

   .
5. Press Alt+F9 to toggle back to the merged data view.

The \# symbol in the switch represents the number format. In this case, "#,##0.00" means that the number should be formatted with a comma for thousands and two decimal places.