نصيحة: اللغات الأخرى مترجمة من قبل Google. يمكنك زيارة English نسخة من هذا الرابط.
تسجيل الدخول
x
or
x
x
التسجيل
x

or

كيفية تنسيق التاريخ والعملة والرقم أثناء دمج المراسلات في ورد؟

دمج المراسلات هو أداة مفيدة لإنشاء مجموعة من الوثائق التي هي في الأساس نفسها ولكن حيث تحتوي كل مستند على عناصر فريدة. ومع ذلك، عند دمج بعض الرسائل، يجب أن نولي المزيد من الاهتمام لتنسيق التاريخ والعملة والرقم. هذا البرنامج التعليمي سوف تظهر لك كيفية تنسيق التاريخ والعملة ورقم صحيح في كلمة أثناء دمج المراسلات.

تنسيق التاريخ بشكل صحيح أثناء دمج المراسلات في ورد

تنسيق العملة ورقم بشكل صحيح أثناء دمج المراسلات في ورد

قبل أن نغير تنسيق التاريخ والرقم والعملة في دمج المراسلات، نحتاج إلى تطبيق العمليات التالية أولا.

الخطوة شنومك: حدد حقل الدمج الذي تريد تغييره. في هذه الحالة، هو حقل التاريخ.

الخطوة شنومك: اضغط مفتاح Shift F9 لجعل حقل الترميز مرئية. يجب أن يبدو الحقل الذي حددته كما يلي:

{ميرجيفيلد ديت}، {ميرجيفيلد كيرنسي} أور {«بيرسنت»}


بسهولة تقسيم وثيقة كلمة واحدة إلى متعددة

بشكل عام، نستخدم النسخ واللصق لتقسيم مستند ورد واحدا تلو الآخر، ولكن الأداة المساعدة سبليت دوكومنيت يمكن تقسيم مستند ورد استنادا إلى الصفحة أو هيدينغكسنومك أو فاصل الصفحات أو فاصل المقطع، مما سيؤدي إلى تحسين كفاءة العمل. انقر للحصول على نسخة تجريبية مجانية كاملة الميزات في أيام 60!
المستندات المقسمة حسب الصفحة
Kutools لـ Word: مع المئات من الوظائف الإضافية في Word سهلة الاستخدام ، يمكنك تجربتها مجانًا بدون أي قيود في أيام 60.

السهم الأزرق الفقاعة اليمنى تنسيق التاريخ بشكل صحيح أثناء دمج المراسلات في ورد

الرجاء إضافة بيانات التنسيق التالية: \ @ "د مم يي" في ملف الدمج من التاريخ. ويجب أن يكون حقل الدمج من التاريخ كما يلي:

{مرجيفيلد ديت \ @ "مم d، يي}}

سيكون تنسيق التاريخ كما يلي:

تغيير-foramt-1

يمكنك تغيير تنسيق التاريخ إلى ما تريد. يمكن أن تكون الأشكال الممكنة الأخرى: • د / م / يي، • د / م / ي، • د مم يي


السهم الأزرق الفقاعة اليمنى تنسيق العملة ورقم بشكل صحيح أثناء دمج المراسلات في ورد

الرجاء إضافة بيانات التنسيق التالية \ # $، شنومكس في ملف دمج العملة، ويجب أن يكون حقل دمج العملة كما يلي:

{مرجيفيلد كيرنسي \ # $، شنومكس}

تغيير-foramt-2

يشار إلى '\ # $، شنومكس' في الحقل بمفتاح صورة رقمي. وتشمل الاحتمالات الأخرى:

(1). \ # شنومك لأرقام كاملة مدورة

(2). \ #، شنومك لأرقام كاملة مدورة مع ألف فاصل

(3). \ #، شنومك للأرقام دقيقة إلى اثنين من المنازل العشرية، مع ألف فاصل

(4). \ # $، شنومك لتقريب الدولار كله مع ألف فاصل

(5). \ # "$، شنومك؛ ($، شنومكس)؛ '-' 'للعملة، مع أقواس حول الأرقام السالبة و واصلة لقيم شنومك

إلى جانب ذلك، قد يكون الرقم في بعض الأحيان نسبة مئوية، قد تحتاج إلى تعديل الحقل {«بيرسنت»} حتى تحصل على {= «بيرسنت» * شنومكس \ # شنومك٪}.

الاستعراض المبوب وتحرير العديد من مستندات Word / مصنفات Excel مثل Firefox ، Chrome ، استكشاف الإنترنت 10!

قد تكون معتادًا على عرض صفحات ويب متعددة في Firefox / Chrome / IE ، والتبديل بينها بالنقر على علامات التبويب المقابلة بسهولة. هنا ، يدعم Office Tab عملية المعالجة المماثلة ، والتي تسمح لك باستعراض مستندات Word متعددة أو مصنفات Excel في نافذة Word واحدة أو نافذة Excel ، والتبديل بينها بسهولة عن طريق النقر فوق علامات التبويب الخاصة بها.
انقر على نسخة تجريبية مجانية من تبويب أوفيس!

تصفح وثائق كلمة متعددة في نافذة واحدة كما فايرفوكس


أوصت كلمة أدوات الإنتاجية

Kutools لـ Word - أكثر من 100 ميزات متقدمة لـ Word ، وفر وقتك 50٪

  • يمكن إجراء العمليات المعقدة والمتكررة لمرة واحدة خلال ثوانٍ.
  • إدراج صور متعددة عبر المجلدات في مستند Word مرة واحدة.
  • دمج ودمج ملفات Word متعددة عبر مجلدات في واحد بالترتيب المطلوب.
  • قسّم المستند الحالي إلى مستندات منفصلة وفقًا للعنوان أو فاصل المقاطع أو معايير أخرى.
  • تحويل الملفات بين Doc و Docx و Docx و PDF ، ومجموعة من الأدوات للتحويلات والتحديدات الشائعة ، وما إلى ذلك ...
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    khoi · 2 months ago
    hi..

    my date changed to code like this; 43696
    anybody can help?
    • To post as a guest, your comment is unpublished.
      Abemus · 1 months ago
      I also facing the same problem... i already tried all the format \@ ..... but still not working.

      Im using word 2013

      Help me plz
  • To post as a guest, your comment is unpublished.
    Heather · 5 months ago
    YOU ARE AMAZING.... after years of fighting with currency in mail merges, finally the easiest and RIGHT answer.
  • To post as a guest, your comment is unpublished.
    cam · 11 months ago
    Hi there, I have my computer region numbering formatted so numbers are x.xxx.xxx,xx however my merge field field code format which is {MERGEFIELD UnitAmount \# "$#.##0,00;-$#.##0,00" \* MERGEFORMAT} still shows the number formatting as xx,xxx.xx. If I remove the formatting, then it displays as xxxx.xxxx
    Anyone know if this is possible and the correct formatting for Danish/German numbers? I need 1,000.00 to display as 1.000,00. Thanks in advance
    • To post as a guest, your comment is unpublished.
      Adix · 8 months ago
      O meu problema é similar: 1500000 => { MERGEFIELD Valor\# #.##0,00 } => 1500.000,00 Entretanto pretendo obter 1.500.000,00
  • To post as a guest, your comment is unpublished.
    Jim · 1 years ago
    Trying to add 14 days to "Current Date" for FISERV letters
  • To post as a guest, your comment is unpublished.
    Osmany Díaz · 1 years ago
    Hello, I am trying to change the date format of a field in Word that is extracted from a database (Oracle), the field arrives with date format as dd-mm-yyyy, but I need to insert that date in mm- dd-yyyy Someone could help me?
    • To post as a guest, your comment is unpublished.
      Adix · 8 months ago
      Other possible date formatting switches include:
      • \@ "dddd, d MMMM yyyy";
      • \@ "ddd, d MMMM yyyy";
      • \@ "d MMM yyyy";
      • \@ "dd/MMM/yyyy";
      • \@ "d-MM-yy"
  • To post as a guest, your comment is unpublished.
    Rene · 1 years ago
    I don't want my number rounded - it must display as is in the database, i.e. must be 8809010578082 not 8809010578100
  • To post as a guest, your comment is unpublished.
    Ian Oldham · 1 years ago
    when I am merging a spreadsheet into a word doc and bringing formatted currency I use \#” £,0.00;(£,0.00)” in the formula but when I do merge it brings back all the blank cells also. How can I just bring the cells with greater than 0 in the merged document
  • To post as a guest, your comment is unpublished.
    everly · 2 years ago
    what if I wanted it blank if it's zero?
    • To post as a guest, your comment is unpublished.
      Sunny · 2 years ago
      Sorry that I cannot help you. I will be appreciate that you can leave a message for me if you find the solving method. Thank u.
      • To post as a guest, your comment is unpublished.
        tps · 1 years ago
        \# "#,##0;(#,##0);' '"
        a space instead of the "-"
  • To post as a guest, your comment is unpublished.
    Natalie · 2 years ago
    Can anyone help me with a code to format my date in Word to display as 1st January 2017? Atm it is formatted to 01/01/2017 but it doesn't look quite right in the main text of a letter.

    Many thanks
    • To post as a guest, your comment is unpublished.
      roja · 9 months ago
      hi can you please guide me,how you are formatting the date in Indian format
      thanks
  • To post as a guest, your comment is unpublished.
    Michelle · 2 years ago
    I am having issues with a mail merge from excel. I need the data to be pulled to come over as a whole number however when it comes over it is is a 0 or the first number of the number represented in excel.

    Examples
    What is is Excel
    31%
    112%
    15%

    What comes over in the merge field
    0
    1
    1

    How do I get the full number to come over? When I change the toggle items to \#0 it then comes over as
    .31
    1.12
    1.5

    Can you assist?

    MB
    • To post as a guest, your comment is unpublished.
      Nessa · 1 years ago
      Did you manage to get help on this? Im facing the same issue
      • To post as a guest, your comment is unpublished.
        Sunny · 1 years ago
        Format the cells as general cannot work?
  • To post as a guest, your comment is unpublished.
    Robin · 2 years ago
    I am wondering how you would format if the field has a zero and you want it to be blank anything greater than zero you want the dollar amount. Thanks.
  • To post as a guest, your comment is unpublished.
    Waseem · 3 years ago
    Dears,
    I have little problem in my mail merge... The display date I need it to be shown in another language like arabic. For example, the date today is "October 30, 2016", when i switch or hit the toggle field code (Alt+F9) it will shown as
    [u]{ MERGEFIELD mydate } --> 10/30/2016[/u]
    When i want to reformate it i will be like the following
    [u]{ MERGEFIELD mydate \@ "ddmmyy"} --> 30102016[/u]
    But when i want it with what i want it to be :
    [u]{ MERGEFIELD mydate \* Arabic} --> 0[/u]

    How can i make the display date look like
    ١٠/٣٠/٢٠١٦

    Thanks and regards
  • To post as a guest, your comment is unpublished.
    Phil · 3 years ago
    Thanks for all the tips!
    I found (in Word 2016) that toggling the field code and manually inserting the switch code didn't really work. I was trying to get the date as dd/MM/yyyy, but Word gave me something else entirely (no idea why the date 10/10/2016 displayed as: 10/00/2016).
    Anyway, I figured out how to get Word to produce the date formatted correctly: Right-click on the merge field and select "Edit field...". Then in the window I clicked on "Field Codes" in the bottom left, and pasted the switch code in the end of the text box.
    Finally it worked!
  • To post as a guest, your comment is unpublished.
    Martin · 3 years ago
    Lanie - I can't work out how to get the - to appear!!
  • To post as a guest, your comment is unpublished.
    Martin · 3 years ago
    Lanie. Set up an excel file with Card No as a heading. Put a 16 digit card number in (no spaces) & merge it to word. Shift F9 to display field & add the \ onward text below

    {MERGEFIELD Card No\# "####-####-####-####"}

    Note I have formatted four # keys & one - key repeating. This seems to produce a space between numbers
  • To post as a guest, your comment is unpublished.
    Lanie · 3 years ago
    I'm trying to make a merge field for credit card number with a format like this 0000-0000-0000-0000 anybody know how.
    Thank you
  • To post as a guest, your comment is unpublished.
    Tanya · 3 years ago
    I am attempting to format the Merge Field to display the Close Date as September 10, 2014 instead of 09/10/14. I have tried to enter the field codes as MERGEFIELD \@ "MMMM dd, yyy" CloseDate and I even tried to Toggle Field Codes. Can anyone offer any suggestions on this? I have tried a few of the suggestions posted here but none have helped in my case.
  • To post as a guest, your comment is unpublished.
    Tanya · 3 years ago
    I am creating a Mail Merge Document from my loan manager database and I have trying to format the date to be September 10, 2014 instead of 09/10/14. I have tried MERGEFIELD \@ "MMMM d, yyy" CloseDate but continually receives an error " Error! Unknown character in picture string" when I toggle field codes.
    • To post as a guest, your comment is unpublished.
      Karen · 3 years ago
      Try MERGEFIELD \@ "MMMM d, yyyy" - I had the message when I used 3 "y"s, but when I changed it to 4, all worked.
  • To post as a guest, your comment is unpublished.
    Hilary Schaub · 3 years ago
    I'm having a very hard time getting a simple currency to export from Excel to Word Mail Merge. I'm getting 13.5 when it sHould be $13.50
  • To post as a guest, your comment is unpublished.
    Shahn · 3 years ago
    [quote name="Serena"]Is there anyway to edit the merge field so that whole numbers do not display decimals .00 but will still include the decimals if there is cents in the merge data? We use merging to prepare thank you letters for donations and my boss doesn't think .00 looks appropriate, especially when the donation is large - $150,000.00 looks funny compared to just putting $150,000.

    Eg.
    Merge Data -> Merge Field
    $1,500.56 -> $1,500.56
    $1,500.00 -> $1,500[/quote]
    Has anyone answered to this query?
    • To post as a guest, your comment is unpublished.
      ELAINE · 3 years ago
      Hi Shahn,

      You can follow the instructions given here to resolve your problem.
      https://support.office.com/en-us/article/Format-mail-merge-numbers-dates-and-other-values-in-Excel-990e6516-49bc-4a43-aecc-acd027d92a00#feedbackText
      However, after selecting MS Excel Worksheets via DDE (*.xls), I click "_FilterDatabase" instead of "EntireSpreadsheet".
      Hope this helps! :)
    • To post as a guest, your comment is unpublished.
      Serena · 3 years ago
      Hi Shahn, no I haven't received any solutions so far.
      • To post as a guest, your comment is unpublished.
        ELAINE · 3 years ago
        Hello,
        I was facing the same problem and manage to solve it by following the instructions here.
        https://support.office.com/en-us/article/Format-mail-merge-numbers-dates-and-other-values-in-Excel-990e6516-49bc-4a43-aecc-acd027d92a00

        However, after selecting "MS Excel Worksheets via DDE (*.xls)", click_FilterDatabase instead of Entire Spreadsheet.

        That will solve the problem.

        I hope it helps! :)
  • To post as a guest, your comment is unpublished.
    Serena · 4 years ago
    Is there anyway to edit the merge field so that whole numbers do not display decimals .00 but will still include the decimals if there is cents in the merge data? We use merging to prepare thank you letters for donations and my boss doesn't think .00 looks appropriate, especially when the donation is large - $150,000.00 looks funny compared to just putting $150,000.

    Eg.
    Merge Data -> Merge Field
    $1,500.56 -> $1,500.56
    $1,500.00 -> $1,500
    • To post as a guest, your comment is unpublished.
      HEIN · 3 years ago
      I have a question, i have a date field {MERGEFIELD "Term_Date_sys" }, but i would like to display that date + 4 months, is it possible?
    • To post as a guest, your comment is unpublished.
      HEIN · 3 years ago
      Hi Serena try this one {MERGEFIELD "Gf_Amount" \$ "R 0 000"}, it also do not display cents although they r there
    • To post as a guest, your comment is unpublished.
      MERI · 3 years ago
      Serena, We use { IF { MERGEFIELD Gf_Amount } = "*.00" "{ MERGEFIELD Gf_Amount \#$,# }" "{ MERGEFIELD Gf_Amount }" } where Gf_Amount is the name of the data field we're merging in.
  • To post as a guest, your comment is unpublished.
    Sandra · 4 years ago
    Thank you very much! :lol:
  • To post as a guest, your comment is unpublished.
    kemod · 4 years ago
    di office 2010 menggunakan MS Excel Worksheet via DDE (*.xls) tidak semua list kolom di excel terbaca karena di excel sampai Kolom LI sedangkan di wor yang terbaca sampai kolom BN
    mohon pencerahannya
    terima kasih
  • To post as a guest, your comment is unpublished.
    Jo · 4 years ago
    Can someone help me with the 'day before' from another merge field?
  • To post as a guest, your comment is unpublished.
    Jessie · 4 years ago
    what about a field with a number and a letter? example "1a". it displays as "0".
  • To post as a guest, your comment is unpublished.
    Jessie · 4 years ago
    How about when the field is a number and letter? example "1a". It appears as "0" on the merge doc.
    • To post as a guest, your comment is unpublished.
      Martin · 4 years ago
      No it doesn't. It might if you try to format it as a date but I am not sure why you would want to do that as it is not a date - well not on earth :D . As 1a is not a date if you want to display 1a just format as text as per Mr. or Mrs. or a client name.
  • To post as a guest, your comment is unpublished.
    Martin · 4 years ago
    Ronel: Used to be done through the use of *Upper within field codes display. Seems to have been dropped by MS. Try this instead:
    When date is displaying as 2-December-2015 or whatever your format is, right click on the date & select FONT. The dialogue box has and ALL CAPS tick box to bottom right. Click it & OK dialogue. Seems to do the trick but the coding is not displayed with Alt+F9 it must be in the background somewhere. Jeez I wish they would just leave it alone!!!!!
  • To post as a guest, your comment is unpublished.
    Ronel · 4 years ago
    I am using the 'd MMMM yyyy' format. Is there a way to format this to upper case?
    • To post as a guest, your comment is unpublished.
      Martin · 4 years ago
      Ronel, When date is displaying right click the date. Select FONT from dialogue. Tick All Caps & then click OK.
      Seems to do the trick on mine
  • To post as a guest, your comment is unpublished.
    Ronel · 4 years ago
    Martin your comments really worked, I am using the "d MMMM yyyy" format and it works perfectly. Is there a way to format this to upper case?
  • To post as a guest, your comment is unpublished.
    martin · 4 years ago
    It does sound unlikely without using visual basic to detect the denomination to rejig the merge field. I think depending on the complexity of the report I would be looking to produce it direct from excel. That may be a total non-starter.
  • To post as a guest, your comment is unpublished.
    Sue · 4 years ago
    I have a list where monetory amounts are to be paid in different currencies - I have done the field toggle for GBP but of course it changes each letter to that but I need some to show USD/SGD etc
    Can you do this within one merge?
  • To post as a guest, your comment is unpublished.
    martin · 4 years ago
    I can only alter the xls merge file contents when other file closed but seems to be formatted Ok with both open. Maybe the first time you need to close the xls file to get formatting to set right when setting up files. If it works go with it.
  • To post as a guest, your comment is unpublished.
    Linda · 4 years ago
    This works for me but ONLY if I close the Excel source file before running the merge.
  • To post as a guest, your comment is unpublished.
    Martin · 5 years ago
    Word 2013 date format on merge from xlsx. Undid Microsoft "fix" switched back to OLE from DDE and your fix worked 2nd time around. Brilliant. Thanks
    • To post as a guest, your comment is unpublished.
      dbhope · 5 years ago
      How do you do this Martin? I'm pulling my hair out.
      • To post as a guest, your comment is unpublished.
        Martin · 5 years ago
        [quote name="dbhope"]How do you do this Martin? I'm pulling my hair out.[/quote]
        Not sure why Microsoft have made this so complicated.

        I think you are just not following the instructions precisely.
        1) Set up an xlsx file with two headings DATE and DATETEXT
        Set format for DATE column to dd/mm/yyyy
        Set format of DATETEXT to text

        2) enter the a these 2 dates in the DATE column:
        01/06/2013
        05/07/2014

        3) enter this text in the DATETEXT column & don't let it format into a date:
        1st Jun 2013
        5th Jul 2014

        4) Save & close file
        5) Open a new word doc
        6) Click mailings, Start mail merge & letters, Select Recipients & use existing list & select the list you just made & click OK

        7) Click Insert merge field & click DATE & then OK
        8) Press enter to move to next line
        9) Click Insert merge field & click DATETEXT & then OK

        10) Click Preview Results & jump through the 2 entries. The DATE field will be showing the date as mm/dd/yyyy REALLY ANNOYING

        11) Click once on the DATE field (to highlight it)
        12) Press SHIFT & F9 and you will see:
        { MERGEFIELD DATE }
        enter this text \@"dd MMM yyyy" so that the field becomes:
        {MEGEFIELD \@dd MMM yyyy" DATE}

        13) VERY IMPORTANT: Note the lower case dd, UPPERCASE MMM, lower case yyyy

        14) Click preview results until the data shows. Scroll through entries & I hope we are sorted.....
  • To post as a guest, your comment is unpublished.
    Martin · 5 years ago
    Formatting the date in word 2013 does not work using \@"dd mmm YYYY" you just get an error to state the field doesn't exist. Microsoft state to use DDE but all that does is give the OOPS SOMETHING WENT WRONG message to appear on opening for the second time.
    • To post as a guest, your comment is unpublished.
      Matthew · 5 years ago
      [quote name="Martin"]Formatting the date in word 2013 does not work using \@"dd mmm YYYY" you just get an error to state the field doesn't exist. Microsoft state to use DDE but all that does is give the OOPS SOMETHING WENT WRONG message to appear on opening for the second time.[/quote]

      Make sure you either right-click on the merge field and choose 'Toggle Field Codes' or press Shift-F9 with the merge field selected.

      So, rather than «LastPaidDate» you should be seeing { MERGEFILD \@ "ddMMMyy" LastPaidDate }
  • To post as a guest, your comment is unpublished.
    Jimbobaleeno · 5 years ago
    Fantastic!. Thanks. I notice also that you can change the format in word to any of the available options in excel. To see the options go to the Excel home tab > format drop down box > more number format options > custom.