Function:formula is displayed, not results

  • Thread starter Thread starter Malcolm Graham
  • Start date Start date
M

Malcolm Graham

I created a VLookup function; I even used the function
wizard to make sure my syntax is correct. The cell where
I created the function shows my keystrokes rather than the
result of the VLookup. The function wizards show me the
result, which is the value I wanted it to be.

But the formula is displayed, not the result of the formula
I am sure the remedy is simple, but I can't fix it.

Malcolm S (the 's' stands for "Stumped") Graham
 
Hi Malcolm,

The cell was probably formatted as text when you entered the formula. Just
formatting afterwards doesn't help.
First format as general, then re-enter the formula.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Simply clicking in the Formula Bar *after* re-formatting the cell will do
the job.
No need to re-enter the formula itself.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi Malcolm,

The cell was probably formatted as text when you entered the formula. Just
formatting afterwards doesn't help.
First format as general, then re-enter the formula.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Of course, you must hit <Enter> after clicking in the Formula Bar.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Simply clicking in the Formula Bar *after* re-formatting the cell will do
the job.
No need to re-enter the formula itself.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi Malcolm,

The cell was probably formatted as text when you entered the formula. Just
formatting afterwards doesn't help.
First format as general, then re-enter the formula.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Thanks, Niek,

That did it!

(Now can you tell me how to make my keyboard type what I
MEAN, and not what my fingers press !??

MG
 
Back
Top