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<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>in
the main
document<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>.
Don't format the data in the data
source<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>,
because its formatting isn't retained when you merge the data into the
document.
Do one of the following:
[image: Show]Change text
formatting<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>
1. In the main document, select the field that contains the information
you want to format, including the surrounding merge field characters (««
»»).
2. 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.
[image: Show]Change
capitalization<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>
1. In the main document, press ALT+F9 to display field
codes<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>.
2. 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.
3. Press ALT+F9 again to hide field codes.
[image: Show]Change other formatting by using field
codes<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>
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.)<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>in
the main document, and then add
switches<mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\wdmain11.chm::/html/woproFormatMergedInformation1.htm#>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*
>
>
>
>
> ______________________________________________________________________________________________________________
>
> Disclaimer :
>
> ______________________________________________________________________________________________________________
>
> This message is intended for the lawful recipient(s) explicitly stated in
> above only.
> It may contain confidential information prohibited for any Unauthorized use
> by any party
> other than the lawful addressee. The message, information and statement
> expressed herein
> should also be legally privileged for the lawful recipient(s).
>
> If you are not the intended recipient(s) or person responsible for
> delivering it to the intended recipient(s),
> you must therefore be notified not to copy, print, distribute or take any
> action in
> reliance on it, directly or indirectly.
>
> ______________________________________________________________________________________________________________
> Please consider ENVIRONTMENT before PRINTING this email .
>
>
>
