View Single Post
  #7   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


of course..you are right!
thks for the advice..Ron!

-via135



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


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