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")
'Mr. Kid' [email protected] [belajar-excel] Mon, 04 May 2015 20:45:57 -0700
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")