On Wed, 15 Mar 2006 22:03:36 -0600, via135
wrote:


hi!

try this!!

B1: =MROUND(A1,100000) assuming your number 16,465,123 is in A1

-via135


davey888 Wrote:
Can you please provide a custom format that will format (for example)
16,465,123 to the nearest 100,000 (16,500,000)


Why use MROUND which requires installation of the Analysis Tool Pak (in
versions prior to Excel 12), when you can use the built-in function ROUND more
simply???

=ROUND(A1,-5)


--ron