Manipulating Round() function in VBA - MrExcel.com

... to be rounded. ie: nearest hundeth, thousanth, ten thousanth, ... =round( number, number of digits) ... You can also use "ceiling" formala for odd rounding, or roundup or rounddown.

www.mrexcel.com