0 error in worksheet

[Guest]

Hi there:
In my timesheet, I have set it up to not print 0's. I have a formula that,
when the answer is 0, and 0 it shows 0 on my screen, but prints as 1E-15. If
the answer is NOT 0, it is ok.
Any ideas?
Thanks!
John

 

[JulieD]

Hi John

what is the formula? what is the formatting of the actual cell (format /
cells , number tab, what's selected?)

Cheers
JulieD

 

[Guest]

Hi JulieD:
Thanks for the reply.
The formula is =(J5-I5-R5-O5)*24. Format is General
O is the cell that causes the equation to equal 0. It is formatted as Custom
H:mm

Thanks again!
John

 

[Frank Kabel]

Hi
try:
=ROUND(J5-I5-R5-O5,0)