Thanks. Unfortunately the function MROUND does not exist on my version of
Excel.

One thing I do not want to do is change the value - using the ROUND function
alters the value thereby affecting subsequent calculations.

The following format rounds to the nearest 1000

#,",000"

but I need to round to the nearest 100,000. Do you or anybody out there no
of workable solutions?

Ta



"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)


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=522954