Format to Round to Tens Digit

A

Andy

I want to format the numbers to round from 1,536 to 1540. I can only find how
to round multiples of a thousand with the custom formats and I am wondering
if there is a way to do this.

Thanks
 
A

Andy

No, I would like to copy and paste values into a cell and have them display
rounded off to the tenths digit.
 
S

Stan Brown

Tue, 29 May 2007 12:20:01 -0700 from Andy
I want to format the numbers to round from 1,536 to 1540. I can only find how
to round multiples of a thousand with the custom formats and I am wondering
if there is a way to do this.
Click to expand...

Look up the ROUND function.
=ROUND(..., -1)
 
Top