Mark Simms
marksimms at verizon.net
Fri Dec 23 07:27:39 CST 2011
Thanks Gustav. Once again, we've got versions 2003, 2007, 2010. Are you sure MSFT did not "fix" Round in later versions ? So bottomline: VBA side....Format and Round produce difference results ? > Hint: The only native function of VB(A) that handles 4/5 rounding > correctly is Format. It is, however, not very fast so if speed is a > concern you have to run a custom function. And no, the VB(A) function > Round is not the answer to any serious task: > > > /gustav