Bonjour,
Pour le principe. A adapter !
Cdlt.
Public Sub ConvertTextInNumber()
Dim ws As Worksheet, tbl As Variant, i As Long, j As Long
Set ws = Worksheets("Sheet1")
tbl = ws.Range("A9:H251").Value
For i = LBound(tbl) To UBound(tbl)
For j = LBound(tbl, 2) To UBound(tbl, 2)
If tbl(i, j) <> "" Then
tbl(i, j) = Replace(tbl(i, j), ".", ",")
tbl(i, j) = Replace(tbl(i, j), Chr(32), "")
tbl(i, j) = Replace(tbl(i, j), Chr(160), "")
tbl(i, j) = CDbl(tbl(i, j))
End If
Next j
Next i
With ws.Range("A9:H251")
.Value = tbl
.NumberFormat = "#,##0.00_ ;[Red]-#,##0.00 ;"
End With
End Sub