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
 

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

Scroll does not show preview 0
Why does forumula show in cell instead of formula result? 2
Function argument not returning a value 11
Excel does not accept text format! 0
Concatenating two text strings, formula is right, cell output is w 3
Despite formula I use (for example SUM) result is always zero. 5
Function displays but not the result - cause????? 5
Show Ink Excel 0

Top