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

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




.