Zero displayed for calculations

G

Guest

I have a user that received and Excel spreadsheet as an attachment. The
spreadsheet works fine from the sender's PC. However, the recipient can not
get calculations to display anything other than "0". I've tried re-entering
the data for the calculations several times. I have checked the formating
for the cells. I have checked to make sure that Auto calculation is turned
on. I've tried using different sheets and cells within the same spreadsheet
and get the same results. No matter what I do, the calculations still
display "0".

Is there something wrong with this file or Excel? Is there something with
the formatting or settings that I am missing? Is there a way to correct this?


Thanks,

Mike
 
G

Guest

When your recipient opens the attached Excel workbook, are there any messages
offered? If so, what are they? If not, click on a cell in which a formula
is supposed to calculate a number. Are the cells referenced populated with
like-kind data? For example, if a formula reads =A1 * B1, are A1 and B1
non-zero numbers or is one or the other a text entry or zero?

More info at your convenience, please.
 

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

Top