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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|