View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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