>>> formula = totext(CDbl({PatReport.Result}), "#0.00") ''for 2 decimal places

When you say that this doesn't work, what do you mean? What are you expecting to see? This formula should show you 0.00 for the value you gave in your example.

Remember that this value is roughly .000949 so rounding to 2 decimal places *is* 0.00. Try rounding to 3 decimal places and you should see 0.001.

When you say that this doesn't work, what do you mean? What are you expecting to see? This formula should show you 0.00 for the value you gave in your example.

Remember that this value is roughly .000949 so rounding to 2 decimal places *is* 0.00. Try rounding to 3 decimal places and you should see 0.001.