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?
|