3 refers to column C (3rd column) adjust to match your column

set rng = Range(Cells(1,3),Cells(rows.count,3).End(xlup))
for each cell in rng
cell.Value = Application.Round(cell.value,2)
Next

--
Regards,
Tom Ogilvy

"projectside" wrote in message
...

2 decimal places.. the data is an average price that looks like this:

197.8938 (i need it to be 197.89)
56.34432 (to be 56.34)
29.3193
78.89345
etc...

something like that...they are all in one column with multiple rows...


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/