1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
Dim nomb As String
Dim calc As Currency
nomb = "25684" 'exemple
'donne comme réponse
calc = 256.84 'calc = 256,84
Stop
calc = nomb / 100 'calc = 256,84
Stop
calc = Val(nomb / 100) 'calc = 256
nomb = "256.84"
calc = Val(nomb) 'calc = 256,84
Stop
calc = nomb 'erreur type incompatible
Stop
nomb = "256,84"
calc = Val(nomb) ' 256
Stop
nomb = "256,84"
calc = nomb 'calc = 256,84
Stop
'donne comme réponse
nomb = Replace(nomb, ",", ".") 'nomb = "256.84"
Stop
calc = Val(nomb) 'calc = 256,84
Stop
nomb = Str(calc) 'nomb = "256.84"
Stop
nomb = CStr(calc) 'nomb = "256,84"
Stop
nomb = Str(calc) 'nomb = "256.84"
calc = CCur(nomb) ' erreur type incompatible
Stop |
Partager