Mengambil pemisah desimalnya pak On Tue, May 5, 2015 at 2:03 PM, hendrik karnadi [email protected] [belajar-excel] <[email protected]> wrote:
> > > Terima kasih Mr. Kid. > Sudah jalan pada Format Indonesian maupun English US > Bagaimana cara membaca *mid(3/2,2,1)*.... yang membuat formatnya menjadi > fleksibel? > Terima kasih. > > Salam, > HK > > > ----- Forwarded Message ----- > *From:* "'Mr. Kid' [email protected] [belajar-excel]" < > [email protected]> > *To:* BeExcel <[email protected]> > *Sent:* Tuesday, 5 May 2015, 10:44 > *Subject:* Re: Fw: [belajar-excel] Fungsi terbilang > > > Coba ubah : > =Text(B3,"000000000000000.00") > menjadi : > =Text( b3 , rept("0",15) & mid(3/2,2,1) & "00" ) > > Regard, > Kid > > > > 2015-05-05 13:33 GMT+10:00 hendrik karnadi [email protected] > [belajar-excel] <[email protected]>: > > =Text(B3,"000000000000000.00") > > > > > > >

