Why does the formula result show a number but the screen shows ze.

J

Jam-Du

I entered a long formula string into Excel. When I click the "fx" button, it
tells me that my formula result is 2.69 but this number does not show on the
spreadsheet. It only shows zero "0".
 
R

Ron Rosenfeld

I entered a long formula string into Excel. When I click the "fx" button, it
tells me that my formula result is 2.69 but this number does not show on the
spreadsheet. It only shows zero "0".
Click to expand...

What is the formula?

What are the inputs to the formula?

What is the cell format?


--ron
 
Top