I have already tried explicit rounding rather than using sprintf but I will also try variations of that.

sprintf, as you used it, didn't round.