Thread: Rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Rounding

Use negative values for ROUND's second argument...

=ROUND(A2,-4)

--
Rick (MVP - Excel)


"Maxine" wrote in message
...
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?