1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Option Explicit
Public Function NbAr(n As Variant) As String
'--- nombre converti en texte arabe
Dim sNb As String
If IsNull(n) Then
NbAr = ""
Else
sNb = CStr(n)
sNb = Replace(sNb, "9", ChrW(&H669))
sNb = Replace(sNb, "8", ChrW(&H668))
sNb = Replace(sNb, "7", ChrW(&H667))
sNb = Replace(sNb, "6", ChrW(&H666))
sNb = Replace(sNb, "5", ChrW(&H665))
sNb = Replace(sNb, "4", ChrW(&H664))
sNb = Replace(sNb, "3", ChrW(&H663))
sNb = Replace(sNb, "2", ChrW(&H662))
sNb = Replace(sNb, "1", ChrW(&H661))
sNb = Replace(sNb, "0", ChrW(&H660))
sNb = Replace(sNb, ".", ChrW(1643))
NbAr = sNb
End If
End Function |
Partager