| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Why does the formula result show a number but the screen shows ze.
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". |
|
#2
|
|||
|
|||
|
Hi
have you checked the format of this cell? -- Regards Frank Kabel Frankfurt, Germany "Jam-Du" schrieb im Newsbeitrag ... 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". |
|
#3
|
|||
|
|||
|
On Fri, 12 Nov 2004 11:48:03 -0800, Jam-Du
wrote: 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". What is the formula? What are the inputs to the formula? What is the cell format? --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Amount or Numbers in Words | New Users to Excel | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Need number of months or weeks passed from formula | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Hybrid Mode
