this one:

MyNum = Round(2 * MyNum, 0) / 2

nothing wrong with it at all!

It's the Round function in itself that doesn't work as it should.

this is what you will get

x = round(1.5,0)

--> x = 2

x = round(2.5,0)

--> x = 2

and that is also why the

MyNum = Round(2 * MyNum, 0) / 2

approach won't work as ppl expect it to work - simply because Round wasn't implemented correctly by microsoft.

Helger