Re: ]] XL-mania [[ format tanggal exel ke MS word

 

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

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.

Change capitalization

1. In the main document, press ALT+F9 to display field codes.
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.

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 <antoni.ginting@kpi.co.id> 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 .

__._,_.___

Messages in this topic (5) Reply (via web post) | Start a new topic

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Ada lowongan jadi direktur ga? Hubungi momods please... :D        |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Recent Activity

•  61
  New Members

Visit Your Group

Give Back

Yahoo! for Good

Get inspired

by a good cause.

Y! Toolbar

Get it Free!

easy 1-click access

to your groups.

Yahoo! Groups

Start a group

in 3 easy steps.

Connect with others.

.

__,_._,___