RE: ]] XL-mania [[ Hitungan Tanggal

[Widodo,Sulistio]

Kalau nggak salah Ms Excel memulai penanggalannya pada tanggal 0 januari 1900, jadi sebagai berikut :   0 = 00-01-1900 1= 01-01-1900 . . . 138 = 17-05-1900 . . . 38854 = 17-05-2006   CMIIW, Widodo. * * * From: XL-mania@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ferdinand Manampiring Sent: Monday, 22 May, 2006 9:08 AM To: XL-mania@yahoogroups.com Subject: Re: ]] XL-mania [[ Hitungan Tanggal   Thanks atas jawabannya, tapi yang saya mau format tgl tsb saat ditulis berubah jadi angka 138. Jadi bukan format tanggal yang saya ingin tapi tanggal 18 mei tersebut adalah hari ke-138. Apa bisa dibantu? Thanks before Ferdinand ----- Original Message ----- From: Aidil Irsyad Kari Mangkuto To: XL-mania@yahoogroups.com Sent: Friday, May 19, 2006 10:01 AM Subject: Re: ]] XL-mania [[ Hitungan Tanggal   Mas, ungkin di block kolom dan baris yang mau di isi tanggal lalu klik kanan ----> format cell ----> date ----> pilih type date yang diinginkan... semoga itu yang dimaksud ----- Original Message ----- From: Ferdinand Manampiring To: xL-mania@yahoogroups.com Sent: Thursday, May 18, 2006 12:54 PM Subject: ]] XL-mania [[ Hitungan Tanggal   Dear milist,   Sekiranya bisa dibantu, misalnya saya menulis 18/5/2006 (dengan format tanggal yang ada) tapi pada cell di mana saya menulis tanggal tersebut langsung tertera angka 138 Boleh diberikan penjelasan untuk rumusnya?   Thanks Ferdinand _____________________________________________________________________ This e-mail has been scanned for viruses by Verizon Business Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com *********************************************************************** The information contained in this email and any attachments may be confidential and is provided solely for the use of the intended recipient(s). If you are not the intended recipient, you are hereby notified that any disclosure, distribution, or use of this e-mail, its attachments or any information contained therein is unauthorised and prohibited. If you have received this in error, please contact the sender immediately and delete this e-mail and any attachments. No responsibility is accepted for any virus or defect that might arise from opening this e-mail or attachments, whether or not it has been checked by anti-virus software. +-:: 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 Microsoft excel Microsoft business solution Microsoft excel help Microsoft small business manager Microsoft excel training 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.