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

"Mike" wrote:

How about:

=round(1536/10,0)*10

Mike



"Andy" wrote:

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