If you have Zero Suppression set (Tools.Options.Zero_Values), then any value
that is rounded to 0 would not be visible.
Example: =ROUND(0.00003333,3) would resolve to 0 and would not be visible.

What formula are you using to round the results?

Note: If you're using a Number Format to round....that only impacts the
display, NOT the value. Zero Suppression reads the value.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Ashley" wrote in message
...
Hi All,

I'm creating a spreadsheet that has some time calculations in it. The
problem is that I want to hide all zero values.

Now, I've already got the spreadsheet set to suppress all zeros, and I've
made sure with conditional formatting and some formulas include
'zero-trapping' as well.

Now, for some calculations, the sheet is returning a value of "0.00" but
the
REAL value of the calculation is 0.00003333.

I've tried rounding the result, to no avail. I've tried setting the
format
to only have two digits, to no avail.

This has been driving me nuts for nearly a week now. Please help!!

Thanks,

Ashley.