Re: ]] XL-mania [[ Data Excel utk Mail Merge

[siti Vi]

Sejajarnya simbol matauang dapat juga dicapai dengan format Accounting       ----- Original Message ----- From: RoëL To: XL-mania@yahoogroups.com Sent: Friday, April 28, 2006 11:06 AM Subject: Re: ]] XL-mania [[ Data Excel utk Mail Merge Supaya sejajar, masukkan rumus ini di format cell   _([$Rp-421]* #,##0_);_([$Rp-421]* (#,##0);_([$Rp-421]* "-"_);_(@_)   Contoh seperti gambar di bawah ini:   ----- Original Message ----- From: Agus Sariyanta To: XL-mania@yahoogroups.com Sent: Wednesday, April 26, 2006 10:51 AM Subject: RE: ]] XL-mania [[ Data Excel utk Mail Merge Terima kasih kepada Pak Andika Bayu dan Pak Ahmad Zamroni. Untuk format tgl sudah bisa, tapi yg format angka (currency) kok ada space di nilai decimal ya .. Antara koma (,) dan 00 jaraknya ada 3 spasi ... contoh : Rp. 1.500.000,   00   Dan nanya lagi, gimana meratakan agar nilai ribuan, ratusan dll sejajar, karena letaknya kurang ngepas. Misal : Rp. 1.500.000,   00            Rp. 350.000,   00   Agar otomatis sejajar ribuannya spt ini : Misal : Rp. 1.500.000,   00            Rp.    350.000,   00   Terima kasih +-:: XL-mania ::::::::::::::::::::----------------------------------+ |                                                                   | | 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  | | [EMAIL PROTECTED] atau kirimkan mereka file dari | | http://groups.yahoo.com/group/XL-mania/files/Promotion/           | +-------------------------------------------------------------------+ | Berikan testimoni Anda tentang XL-mania di :                      | | http://www.friendster.com/profiles/xlmania                        | +-------------------------------------------------------------------+ SPONSORED LINKS Business application software Microsoft excel training Microsoft excel tutorial Business application development Microsoft excel help Microsoft excel training course YAHOO! GROUPS LINKS  Visit your group "XL-mania" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.