The format number property only affects the display of numbers, not their actual value. In a formula use the Round(number, decimal) function.

eg Round(4.234, 1) = 4.3

If the value to the right of the decimal point is .5 or above, it rounds to the next highest number.

if i understood correct i think
if you got any number in the 2nd decimal place it should be rounded

ie. 4.21 to 4.29 it should be 4.30

if so try this code :(formula field) consider x as the number (4.234)

if Round(X,2)-Round(X, 1)>=0.01 then
truncate(X,1)+0.1
else
X




Edited by Senthil Raj - 17 Oct 2010 at 11:50pm