| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Results
All my formula results display a 0 in the cell. I see the correct result in
the Formula Argument box. The cell format is general. And I have the same result with IF formula or VLookup. -- Fluteplayer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Results
I would check the formats that are assigned to all the cells displaying
zeroes, to rule out an errant format assignment. -- Kevin Backmann "Fluteplayer" wrote: All my formula results display a 0 in the cell. I see the correct result in the Formula Argument box. The cell format is general. And I have the same result with IF formula or VLookup. -- Fluteplayer |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Results
If the data are numbers, perhaps they have been entered as Text?
Copy an empty cell. Select the range of "numbers" and EditPaste SpecialAddOKEsc. If not the above then post some sample data and a formula or two. Gord Dibben MS Excel MVP On Fri, 6 Jun 2008 10:12:01 -0700, Fluteplayer wrote: All my formula results display a 0 in the cell. I see the correct result in the Formula Argument box. The cell format is general. And I have the same result with IF formula or VLookup. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
| View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
| Modifying a formula to display the results of another formula | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Linear Mode
