nah ini baru oce... mosok soal begini saja harus mendatangkan penulis makro, ya ndak..
data yg di excel bisa "tidak perlu diformat" tapi di konversi misal *C3 *harus berupa tanggal yg akan dipakai pengisi mail-merge di word tanggal di excel* jangan ditulis di C3* tetapi di cell lain *misal A3* lalu di *C3 ditulis =TEXT(A3,"DD-MMMM-YYYY")* hasil / tampilannya di cell C3 adalah data type teks misal "20 September 2009" sesampainya di Word harusnya masih tetap seperti itu. On Wed, Sep 16, 2009 at 8:16 AM, helmi triyanto <[email protected]> wrote: > > To Antoni Ginting > Dulu juga saya pernah mengalami hal seperti tersebut, tetapi mudah2an ini bisa membantu : > > > Format merged data > To format merged data, you must format the merge fields in the main document. Don't format the data in the data source, because its formatting isn't retained when you merge the data into the document. > > Do one of the following: > Change text formatting > > In the main document, select the field that contains the information you want to format, including the surrounding merge field characters («« »»). > On the Format menu, click a command, such as Font or Paragraph, and then select the options you want. > > Note If you're creating envelopes, you can also choose the delivery address font while you're setting options on the Envelope Options tab during the mail merge. > > Change capitalization > > In the main document, press ALT+F9 to display field codes. > Immediately following the name of the field (ADDRESSBLOCK, GREETINGLINE, or MERGEFIELD), type a space, and then type one of the following formatting switches: \* Caps Capitalizes the first letter of each word. \* FirstCap Capitalizes the first letter of the first word. \* Upper Capitalizes all letters. \* Lower Formats all letters as lowercase. > Press ALT+F9 again to hide field codes. > > Change other formatting by using field codes > > To control other aspects of formatting, press ALT+F9 to display field codes (field code: Placeholder text that shows where specified information from your data source will appear; the elements in a field that generate a field's result. The field code includes the field characters, field type, and instructions.) in the main document, and then add switches to the merge fields. > > For example: > > To display the number "34987.89" as "$34,987.89," add a numeric picture switch (\# $#,###.00). > To display the number "0945" as "9:45 PM," add the date/time picture switch (\@ "h:mm am/pm"). > To ensure that the merged information has the same font and point size you apply to the merge field, add the \* MERGEFORMAT switch > > Mungkin 2 baris terakhir bisa membantu. caranya blok text hasil insert merge field, misal 20-September-09, kemudian klik kanan dan filih "Toggle Field Codes". kemudian akan keluar {MERGEFIELD "Field Name"}, tambahkan pada code tersebut \@ "DD-MMMM-YY" jadi hasilnya {MERGEFIELD "Field Name" \@ "DD-MMMM-YY"}. Setelah itu klik kanan kembali dan pilih "Update Field" > > Selamat menikmati. > Helmi > > On Tue, Sep 15, 2009 at 8:33 PM, Antoni Ginting <[email protected]> wrote: >> Dear Pakar, >> Setelah berkutat dan coba mencoba, akhirnya ku harus bertanya jg nih. Sepertinya simple tapi tak kudapat. >> >> Bagaimana caranya agar format tanggal di excel tidak berubah ketika di merger ke MS word. >> >> excel >> hasil Merger ke MS word >> 20-September-09 >> 09/20/09 >> 22-September-09 >> 09/22/09 >> 23-September-09 >> 09/23/09 >> 24-September-09 >> 09/24/09 >> 25-September-09 >> 09/25/09 >> 26-September-09 >> 09/26/09 >> Maunya ketika di merger di word hasilnya tetap seperti format excel. >> Best Regards, >> Antoni Ginting >>
