Solved: delete from nth character

[thmh]

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
...

[GTO]

Presuming they are numbers, have you tried: =ROUND(A2,2)

[VoG]

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]

[GTO]

Errr... You actually did not mention rounding. To just delete, maybe TRUNC()

=TRUNC(A2,2)

[thmh]

tnx
both solutions worked