Format to Round to Tens Digit
 

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

Format to Round to Tens Digit
 

Andy

A format will only alter the display, why not use a formula like

=ROUND(A1,-1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Andy" wrote in message
...
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

Format to Round to Tens Digit
 

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

Format to Round to Tens Digit
 

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

Format to Round to Tens Digit
 

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.

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

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/