A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Formatting Long Documents
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formating fields in mail merge



 
 
Thread Tools Display Modes
  #1  
Old February 14th, 2010, 05:14 AM posted to microsoft.public.il.office,microsoft.public.word.formatting.longdocs
Tamir
external usenet poster
 
Posts: 16
Default Formating fields in mail merge

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


  #2  
Old February 14th, 2010, 05:58 AM posted to microsoft.public.il.office,microsoft.public.word.formatting.longdocs
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Formating fields in mail merge

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


  #3  
Old February 14th, 2010, 06:18 AM posted to microsoft.public.il.office,microsoft.public.word.formatting.longdocs
Tamir
external usenet poster
 
Posts: 16
Default Formating fields in mail merge

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




  #4  
Old February 14th, 2010, 09:08 AM posted to microsoft.public.word.formatting.longdocs,microsoft.public.il.office
מיכאל (מיקי) אבידן
external usenet poster
 
Posts: 562
Default Formating fields in mail merge

עפ"י שמך א*י מרשה לעצמי לצאת מ*ק' ה*חה שאתה קורא גם עברית - ולכן אעצתי לך
לבדוק דרך *וספת, שלדעתי, הי*ה פשוטה מאד:
בגיליון ה'אקסל' - לצד ה*תו*ים המספריים - פתח עמודת עזר והצג בה את המספרים
בעזרת הפו*קציה: 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




.

  #5  
Old February 14th, 2010, 03:40 PM posted to microsoft.public.word.formatting.longdocs
dhaval
external usenet poster
 
Posts: 1
Default Formating fields in mail merge


Tamir;457502 Wrote:
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.




--
dhaval
  #6  
Old February 14th, 2010, 11:01 PM posted to microsoft.public.word.formatting.longdocs
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Formating fields in mail merge

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.