Sub nbre()
Dim Rng As Range
For Each Rng In Range("A5:A9") 'A adapter bien sure
Rng.Replace What:=Chr(160), Replacement:="", LookAt:=xlPart
Rng.Value = CDbl(Rng.Value)
Next
End Sub
Sub nbre()
Dim Rng As Range
For Each Rng In Range("A1:A9")
Rng.Replace What:=Chr(160), Replacement:="", LookAt:=xlPart
Rng.Replace What:=Chr(44), Replacement:=".", LookAt:=xlPart
Next
End Sub
=SUBSTITUE($C5;CAR(160);"")*1