Yes, that will work, too, but the idea of negative number of decimal places
has always seemed strange to me <g.

On Sat, 19 Feb 2005 15:58:01 -0000, "Sandy Mann"
wrote:

Why not simply

=ROUND(A1,-3)

Regards

Sandy