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")
>
>
>
>
>
>   
>

Kirim email ke