coba formula ini Om =IF(ISNUMBER(D2);D2;VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D2;"$";"");"cr";"");",";"");".";"")/100)) -------------- copy ke bawah di formula ini kita menghilangkan karakter non number pake substitute file terlampir
--- Pada Rab, 15/5/13, jimmy sihombing <[email protected]> menulis: Dari: jimmy sihombing <[email protected]> Judul: ]] XL-mania [[ text ubah ke number Kepada: "XL-mania" <[email protected]> Tanggal: Rabu, 15 Mei, 2013, 4:37 AM Hallo Dear All Master, Saya punya kasus (file terlampir). Thanks, JHE
re (xl-mania)-text ubah ke number.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
