Coba formula : (untuk berangkat) -> regional setting komputer english ya =IF(B3<1,B3,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3,"'",":"),"""",":"),".",":"),",",":")*1)
Wassalam, Kid. On Fri, Feb 20, 2015 at 6:48 PM, Dede pmaho_l...@nabatisnack.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote: > > > Dear Be Exceler, > > > > Mohon bantuan dari rekan-rekan sekalian terkait kasus terlampir. > > > > Salam, > > DD > > ------------------------------ > This e-mail and any files transmitted with it are confidential and > intended solely for the use of the individual to whom it is addressed. If > you have received this email in error please send it back to the person > that sent it to you. Any views or opinions presented are solely those of > its author and do not necessarily represent those of NABATI or any of its > subsidiary companies. Unauthorized publication, use, dissemination, > forwarding, printing or copying of this email and its associated > attachments is strictly prohibited. > > >
