0 error in worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi John

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

Cheers
JulieD
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing error when the answer is 0 2
error when answer is 0 1
Excel VBA 1
Excel Need Countifs Formula Help 0
#DIV/0! ERROR 2
Rounding hh:mm to nearest 15, 30, 45 minutes 4
data links on subsequent worksheets 2
OR in SUMPRODUCT formula 3

Back
Top