Use the VBA library to round to a specific number of decimal ...

VBA.Round uses "banker's rounding." That means if the digits to be dropped contain exactly 5, then VBA.Round rounds the value to the nearest even number.

www.vb-helper.com