I have a top hits table with a hits and at bats field . In order to get the batting average hits/atbats but the total i am am getting is too long i need to round it or specify somehow that i only want 3 spaces after the decimal .360 instead of .3604759837458. I have searched help and everywhere i could find on the net. Can it be done and if so how?


Thx, Sean

Int(UnRoundedValue * 10 ^ 3 + 0.5) / 10 ^ 3

HTH
RDH

Didnt work

Thx so much !!!