ActiveCell.TextToColumns Destination:=ActiveCell
Range("A1:A10").TextToColumns Destination:=Range("A1")
Sub Numérique()
'
' Numérique Macro
'
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim T As String, X, Elt As Variant, K&
Dim Rg As Range, C As Range
X = xlNumberAsText
With ActiveSheet
K = Cells(65536, 3).End(xlUp).Row
Set Rg = .Range("L1:H" & K)
On Error Resume Next
For Each C In Rg
With C
If C <> vbNullString Then
T = C.Value
For Each Elt In Array(" ", Chr(160))
T = Replace(T, " ", "")
Next
T = Replace(T, ".", Format(0, "."))
.NumberFormat = "General" 'Standard
.Value = CDbl(T)
End If
End With
Next
End With
Set Rg = Nothing
Application.Calculation = xlCalculationAutomatic
'
End Sub
Sub CTN()
Dim r As Range, c As Range, n#
Set r = Selection
For Each c In r
n = c: c = n
Next c
End Sub
Sub toto()
Dim oCel As Range
On Error Resume Next
For Each oCel In Selection.Cells
If Not IsEmpty(oCel) Then oCel.Value = --oCel.Value
Next
End Sub
Sub test()
Selection = Selection.Value
End Sub
Plus concis, tu meurs.Bonjour
ou encore
Code:Sub test() Selection = Selection.Value End Sub