Decreasing decimal places for multiple columns.

Hi there,

Could someone help me with a macro that would decrease the number of decimal places from 5 to 1, for the range of column O10 (and down) to column U10 (and down)?

Right now they have values of 2012.4340293 and would like to have it only 2012.4.


THanks

Thanks,

I've tried changing the code to:

Range("O10:U & lastrow").NumberFormat = "0.0"

so that it could change all the decimal places in those 2 columns to 0.0, but i'm getting an error "Method range of object worksheet failed"

Any help?