formula result is zero but zero is not populating in cell

P

pscaccetti

I am working in MS Excel 2003 and am using three worksheets for this
project. The first 2 worksheets contain numerical data and the 3rd
worksheet is where I have formulas using values from the other
worksheets. When there is a zero value entered on worksheet 1 and the
formula on worksheet 3 has a result of zero, the zero value is not
populating. I have 'zero values' checked under Options and the cells
are formatted 'General'. Does anyone know how I can get the cell with
the formula to populate a zero when the formula result equals zero?
Thanks in advance for your help.

Pat
 
S

Sheeloo

What happens if you directly type a zero in the cell? Do you see that?

If yes, then it means that your formula is not returning a zero...

What does
=CODE(A1)
return (assuming you have the formula in A1)... if you have zero then it
should give you 48.

Failing all the above pl. share the formula... and the values in cells it is
referring to...
 
P

pscaccetti

What happens if you directly type a zero in the cell? Do you see that?

If yes, then it means that your formula is not returning a zero...

What does
=CODE(A1)
return (assuming you have the formula in A1)... if you have zero then it
should give you 48.

Failing all the above pl. share the formula... and the values in cells itis
referring to...






- Show quoted text -

When I type a zero directly in the cell I don't see it.

Here's the formula: ='PP,DDU & CSS'!H12
H12 is the cell from worksheet 1 and the value of that cell is 0
(zero). The formula is on worksheet 3.
 
S

Sheeloo

What did you get with
=Code(A1) after replacing A1 with the cell address with the formula...

Did you try to enter any other number? Does that show up?

Only thing I can think of is that FONT color of that cell is WHITE...

Can you upload the file at wikisend.com and paste the link here?
Excel version? Should not matter...
 

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