Utk rupiahnya, mungkin boleh dicoba script makro
dibawah ini :
Function Stext(angka As Integer, satu As Boolean)
As String
Select Case angka Case 1 If (satu) Then Stext = "SATU " Else Stext = "SE" Case 2 Stext = "DUA " Case 3 Stext = "TIGA " Case 4 Stext = "EMPAT " Case 5 Stext = "LIMA " Case 6 Stext = "ENAM " Case 7 Stext = "TUJUH " Case 8 Stext = "DELAPAN " Case 9 Stext = "SEMBILAN " End Select End Function Function SSStext(tigaangka As Integer, satu As Boolean) As String Dim ibelas As Integer Dim angka3 As Integer Dim angka2 As Integer Dim angka1 As Integer Dim text1 As String Dim text2 As String Dim text3 As String
angka3 = tigaangka Mod 10 ibelas = tigaangka Mod 100 angka2 = Fix(ibelas / 10) angka1 = Fix(tigaangka / 100)
'masalah 'seribu' If (tigaangka = 1) Then text3 = Stext(angka3, satu) Else: text3 = Stext(angka3, True) End If
'masalah belasan If (ibelas > 10 And ibelas < 20) Then If (ibelas = 11) Then text2 = "SE" Else text2 = text3 text3 = "BELAS " Else: 'default If (angka2 > 0) Then text2 = Stext(angka2, False) + "PULUH "
End If
If (angka1 > 0) Then text1 = Stext(angka1, False) + "RATUS "
SSStext = text1 + text2 + text3
End Function Function Terbilang(angka As Long) As String Dim iSat As Integer Dim iRib As Integer Dim iJut As Integer Dim sisa As Long Dim temptext As String
iSat = angka Mod 1000 sisa = Fix((angka - iSat) / 1000) iRib = sisa Mod 1000 sisa = Fix((sisa - iRib) / 1000) iJut = sisa Mod 1000
If (iJut > 0) Then temptext = SSStext(iJut, True) + "JUTA " If (iRib > 0) Then temptext = temptext + SSStext(iRib, False) + "RIBU " If (iSat > 0) Then temptext = temptext + SSStext(iSat, True) Terbilang = temptext
End Function
salam
|
Title: RE: [milis-komputeraktif] Permasalahan Excel {02}