Thread: Custom formats to round numbers such as 16,465,123 to 16,500,000
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
via135
 
Posts: n/a
Default Custom formats to round numbers such as 16,465,123 to 16,500,000

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

Reply With QuoteReply With Quote