Sounds like the cell was formatted as 'text' before the formula was entered.

Click in the cell, then:

<Ctrl <Shift < ~
Then
<F2
Then
<Enter

If that works, then it definitely was formatted to text prior to the formula
entry.

Those keystrokes were simply a shortcut to:
Format the cell to 'General',
Enter the 'Edit' mode,
Register the revision.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gilbert" wrote in message
...
Thanks for the response Mark,

Yes I have and it's no checked.

"MarkN" wrote:

Gilbert,

Have you tried going Tools, Options and then select the View tab. Make
sure
that the tick is not in the Formulas box.

--
Hope this helps,
MarkN


"Gilbert" wrote:

The problem that I'm getting when using the vlookup is that the only
answer
that I get is the formula it self. As I am entering the formula in the
dialogue box, the dialogue box displays the correct value but when I
click
OK, it returns the formula instead of the correct value.

The format on both columns are the same. Any help would be greatly
appreciated.