hy,
have numeric data in sheet1
-------A-------------------B
1 23,222255566
2 3,5539522
3 28,4555222233
...
need to delete everything after second decimal place
-----A---------B
1 23,22
2 3,55
3 28,45
...
hy,
have numeric data in sheet1
-------A-------------------B
1 23,222255566
2 3,5539522
3 28,4555222233
...
need to delete everything after second decimal place
-----A---------B
1 23,22
2 3,55
3 28,45
...
Presuming they are numbers, have you tried: =ROUND(A2,2)
Try this
[VBA]Sub ATest()
Dim LR As Long, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 1 To LR
Range("A" & i).Value = Round(Range("A" & i).Value, 2)
Next i
End Sub
[/VBA]
Errr... You actually did not mention rounding. To just delete, maybe TRUNC()
=TRUNC(A2,2)
tnx
both solutions worked