Di Word - nya, mungkin
{ MERGEFIELD Date_PKWT }
dapat anda ganti dengan:
{ Date_PKWT \@ "h:mm am/pm, dddd, MMMM d" }
Lebih lengkapnya.. anda dipersilakan mengunjungi minimal "salah dua" sites
ini (Kalau Mau!..)
http://www.ehow.com/how_4619985_numbers-ms-word-mail-merge.html
http://cybertext.wordpress.com/2009/06/27/word-change-date-format-from-excel-data/
http://www.gmayor.com/formatting_word_fields.htm
http://office.microsoft.com/en-us/word-help/date-time-picture-field-switch-HP005186227.aspx
sebagian kutipan dari Microsoft.com
*Date-Time format switch*
The Date-Time format switch (\@) specifies the display of a date or time.
For example, the switch \@ "dddd, MMMM d, yyyy" in the field { DATE \@
"dddd, MMMM d, yyyy" } displays "Friday, November 23, 2007." Combine the
following date and time instructions — day (d), month (M), and year (y);
hours (h) and minutes (m) — to build a date-time format. You can also
include text, punctuation, and spaces.
*Date instructions*
Month (M)
The letter M must be uppercase to distinguish months from minutes.
M This format item displays the month as a number without a leading 0
(zero) for single-digit months. For example, July is 7.
MM This format item displays the month as a number with a leading 0
(zero) for single-digit months. For example, July is 07.
MMM This format item displays the month as a three-letter abbreviation.
For example, July is Jul.
MMMM This format item displays the month as its full name.
Day (d)
The letter d displays the day of the month or the day of the week. The
letter dcan be either uppercase or lowercase.
d This format item displays the day of the week or month as a number
without a leading 0 (zero) for single-digit days. For example, the sixth
day of the month is displayed as 6.
dd This format item displays the day of the week or month as a number
with a leading 0 (zero) for single-digit days. For example, the sixth day
of the month is displayed as 06.
ddd This format item displays the day of the week or month as a
three-letter abbreviation. For example, Tuesday is displayed as Tue.
dddd This format item displays the day of the week as its full name.
Year (y)
The letter y displays the year as two or four digits. The letter y can be
either uppercase or lowercase.
yy This format item displays the year as two digits with a leading 0
(zero) for years 01 through 09. For example, 1999 is displayed as 99, and
2006 is displayed as 06.
yyyy This format item displays the year as four digits.
*Semprull.. Ki !*
*2012/2/13 Joe Dien <shiman...@ymail.com>
>
> Dear Master exceller....
> saya ingin mengambil data dari excell ke word.
> yang menjadi pertannyaan saya adalah :
> - Bisakah kita ambil data dari excell ke word hanya sebagian (di excell
tertulis 15 Januari 2012) kami hanya mau ambil bulannya saja/tahunnya saja
di word (januari/2012)
> - bagaimana merubah data dari date ke Text (di excell 15 januari 2012)
jika di pindah ke word hanya muncul angka...
>
> just informasi:
> data ini kami ambil dari excell ke word menggunakan"Select data source"
> saya harap exceller mengerti bahasa saya..... heeeee
> mohon pencerahannya ya......
> regards,
> Joedien*
