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/