| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell shows only formula, no result
I have run into this a few times and forgot how I solved it before. I am doing a simple vlookup in Excel 2003 and instead of giving me a formula result the cell just retains the text of the formula. What option or fomatting do I need to change? -- alexrm |
|
#2
|
|||
|
|||
|
Change the format of the cell to Numeric or ... Select the Cell. Hit F2 and
then Enter... -- HTH... Jim Thomlinson "alexrm" wrote: I have run into this a few times and forgot how I solved it before. I am doing a simple vlookup in Excel 2003 and instead of giving me a formula result the cell just retains the text of the formula. What option or fomatting do I need to change? -- alexrm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| VLOOKUP formula appears in the cell I need to see the result in | Excel Discussion (Misc queries) | |||
| Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
| looking for a formula | Excel Worksheet Functions | |||
Linear Mode
