Thanks everyone! I appreciate your help.
Dave

"Ron Rosenfeld" wrote:

On Wed, 15 Mar 2006 19:19:03 -0800, 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)


You cannot do this with formatting. The closest you can come with formatting
is to the nearest 10^n where n is a multiple of 3.

So to display to the nearest 10^6, for example:

Format/Cells/Number Custom Type: #,###,,",000,000"

To display how you specify, you will have to ROUND the number. This, of
course, would change the value for use in subsequent calculations.

e.g. =ROUND(A1,-5)

--ron