| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is formula displayed?
I am in cell G307. This is my formula:
=VLOOKUP(F306,$f$27:$g306,2) This is the results: VENDOR ONE But when I hit enter to finalize the formula, the formula is displayed in the cell not the answer. How can I correct this so that the results are visible and the formula is not shown in the cell? Other formulas are working correctly, but I do have a filter on if that makes any difference. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is formula displayed?
The cell was formatted as text before you entered the formula.
Format as General (or number) AND re-enter the formula (F2, ENTER): just re-formatting is not enough. -- Kind regards, Niek Otten Microsoft MVP - Excel "evoxfan" wrote in message ... I am in cell G307. This is my formula: =VLOOKUP(F306,$f$27:$g306,2) This is the results: VENDOR ONE But when I hit enter to finalize the formula, the formula is displayed in the cell not the answer. How can I correct this so that the results are visible and the formula is not shown in the cell? Other formulas are working correctly, but I do have a filter on if that makes any difference. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is formula displayed?
Hi Niek,
I encountered the same problem, reformatted the cells to number and here's what happened: 1) when I keyed in a cell-by-cell formula, it worked: =A48+A44+A38+A32+A26+A20+A14+A8+A3 2) when I try to sum a range with the auto sum button, which returns =SUM(A3:A48), I get zero. I just switched to Excel 2007; NEVER had this problem with 2003. There must be something really dumb I am overlooking. Thanks for your help! Rita "Niek Otten" wrote: The cell was formatted as text before you entered the formula. Format as General (or number) AND re-enter the formula (F2, ENTER): just re-formatting is not enough. -- Kind regards, Niek Otten Microsoft MVP - Excel "evoxfan" wrote in message ... I am in cell G307. This is my formula: =VLOOKUP(F306,$f$27:$g306,2) This is the results: VENDOR ONE But when I hit enter to finalize the formula, the formula is displayed in the cell not the answer. How can I correct this so that the results are visible and the formula is not shown in the cell? Other formulas are working correctly, but I do have a filter on if that makes any difference. Thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is formula displayed?
The "ne,bers" you are trying to sum are text, not numbers. The SUM()
function and the addition operator treat them differently. Copy an empty cell. Select the "numbers". PastePaste Special, check Add. Now they are numbers. -- Kind regards, Niek Otten Microsoft MVP - Excel "Rita" wrote in message ... Hi Niek, I encountered the same problem, reformatted the cells to number and here's what happened: 1) when I keyed in a cell-by-cell formula, it worked: =A48+A44+A38+A32+A26+A20+A14+A8+A3 2) when I try to sum a range with the auto sum button, which returns =SUM(A3:A48), I get zero. I just switched to Excel 2007; NEVER had this problem with 2003. There must be something really dumb I am overlooking. Thanks for your help! Rita "Niek Otten" wrote: The cell was formatted as text before you entered the formula. Format as General (or number) AND re-enter the formula (F2, ENTER): just re-formatting is not enough. -- Kind regards, Niek Otten Microsoft MVP - Excel "evoxfan" wrote in message ... I am in cell G307. This is my formula: =VLOOKUP(F306,$f$27:$g306,2) This is the results: VENDOR ONE But when I hit enter to finalize the formula, the formula is displayed in the cell not the answer. How can I correct this so that the results are visible and the formula is not shown in the cell? Other formulas are working correctly, but I do have a filter on if that makes any difference. Thanks in advance. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is formula displayed?
Thanks! It worked.
"Niek Otten" wrote: The "ne,bers" you are trying to sum are text, not numbers. The SUM() function and the addition operator treat them differently. Copy an empty cell. Select the "numbers". PastePaste Special, check Add. Now they are numbers. -- Kind regards, Niek Otten Microsoft MVP - Excel "Rita" wrote in message ... Hi Niek, I encountered the same problem, reformatted the cells to number and here's what happened: 1) when I keyed in a cell-by-cell formula, it worked: =A48+A44+A38+A32+A26+A20+A14+A8+A3 2) when I try to sum a range with the auto sum button, which returns =SUM(A3:A48), I get zero. I just switched to Excel 2007; NEVER had this problem with 2003. There must be something really dumb I am overlooking. Thanks for your help! Rita "Niek Otten" wrote: The cell was formatted as text before you entered the formula. Format as General (or number) AND re-enter the formula (F2, ENTER): just re-formatting is not enough. -- Kind regards, Niek Otten Microsoft MVP - Excel "evoxfan" wrote in message ... I am in cell G307. This is my formula: =VLOOKUP(F306,$f$27:$g306,2) This is the results: VENDOR ONE But when I hit enter to finalize the formula, the formula is displayed in the cell not the answer. How can I correct this so that the results are visible and the formula is not shown in the cell? Other formulas are working correctly, but I do have a filter on if that makes any difference. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula showing 0 - don't want it displayed | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| formula displayed instead of the result ??? | Excel Worksheet Functions | |||
Linear Mode
