Range("B5:T9").Select
Application.CutCopyMode = False
Selection.NumberFormat = "0.0"
Range("V1").Select
Selection.Copy
Range("B5:T9").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply, _
SkipBlanks:=False, Transpose:=False
sub tt()
dim Zelle as object
for each Zelle in Selection
sendkeys "{F2}", true
sendkeys "{ENTER}", true
next Zelle
end sub
Sub Text_in_Zahl()
Dim Zelle As Range
Dim var As Variant
On Error Resume Next
For Each Zelle In Selection
var = Zelle.Value
Zelle.ClearFormats
Zelle.NumberFormat = "#.###"
Next
End Sub
Sub Text_in_Zahl()
Dim Zelle As Range
Dim var As Variant
On Error Resume Next
For Each Zelle In Selection
var = Application.Substitute(Zelle, ",", ".")
Zelle.ClearFormats
Zelle.Value = var
Zelle.NumberFormat = "#.###"
Next
End Sub