Thread: Rounding
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
francis francis is offline
external usenet poster
 
Posts: 120
Default Rounding

try

=MROUND(A1,10000)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Maxine" wrote:

I have a column of figures that I need to round to the nearest 10,000. How
do I do it and can I do this in bulk or do I have to do one cell at a time?