error when answer is 0

G

Guest

Hi there:
I have a time sheet that is producing an error. The answer is 0, and that is
what is on my screen, but when printed, it prints 1E-15. If the answer is NOT
0, it works fine. I have the sheet set up to not print 0's.
Any ideas?
Thanks!
Johnnyjomp
 

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
0 error in worksheet 3
Printing problems with hidden rows 1
VLOOKUP displaying "NO ANSWER" instead of "0" 2
Imposs? Speed up 1
When I link blank cell in one sheet registers as 0 for averaging 3
Formula Discrepancy 2
Formulas calculate the answer wrongly as 0 1

Top