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