formula result is zero but zero is not populating in cell

  • Thread starter Thread starter pscaccetti
  • Start date Start date
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
 
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...
 
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 -
Click to expand...

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.
 
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...
 
Back
Top