Re: ]] XL-mania [[ menjadikan text data menjadi angka

[abimono]

Hai bamb...@office

=VALUE(SUBSTITUTE((SUBSTITUTE(SUBSTITUTE(A1,"Rp.",""),",-","")),".",""))

thank you and regards,

- abimono -

disubstituteinajaahhh.xls
Description: MS-Excel spreadsheet