Alhamdulillah sudah bisa mas Matzen….
Regards CW From: [email protected] [mailto:[email protected]] Sent: Kamis, 24 Agustus 2017 10.44 To: [email protected] Subject: RE: [belajar-excel] Penomoran otomatis Dear CW Udah di coba format nya belom?general jadi custom Terima Kasih Matzen From: [email protected] <mailto:[email protected]> [mailto:[email protected]] Sent: 24 Agustus 2017 10:15 To: [email protected] <mailto:[email protected]> Subject: RE: [belajar-excel] Penomoran otomatis [1 Attachment] Saya sedikit penasaran dengan formula Mr. Kid nih… Waktu sy coba di worksheet yang lain ternyata muncul angka2 negatifnya…sy kira untuk ‘menghilangkan’ angka2 negatif pake conditional formatting dengan memberi warna putih pada angka2 negatifnya…terus sy coba clear formatnya ternyata di formula Mr. Kid tetap ga tampil tuh yg angka2 negatifnya. Itu pake format apa ya Mr?.... Yg saya laukan saat ini dengan cara buat conditional formatting, sy bikin putih angka2 negatifnya. Regards CW From: [email protected] <mailto:[email protected]> [mailto:[email protected]] Sent: Rabu, 23 Agustus 2017 19.11 To: BeExcel <[email protected] <mailto:[email protected]> > Subject: Re: [belajar-excel] Penomoran otomatis [1 Attachment] Hai Cep, Coba pelajari lagi tentang fungsi IF. Regards, Kid 2017-08-23 15:09 GMT+07:00 'CepWahyu' [email protected] <mailto:[email protected]> [belajar-excel] <[email protected] <mailto:[email protected]> >: Dear Be-Exceller, Bisakah di excel dibuat penomoran otomatis? Penjelasan detail terlampir. Regards CW ____________________________________________________________________________ This email has been scanned by AkzoNobel for Viruses and Spam. For more information please contact your local IT Service Desk. ____________________________________________________________________________
