VLOOKUP formula help

[sp1974]

Ok so I am using a VLOOKUP and entered =VLOOKUP(B8,'Master Pak Number list'!A2:I252,2,false) and everything should be right but when I hit enter the only thing it displays is the formula. Any ideas on whats wrong?

[barrfly]

try ctrl ~

[sp1974]

CNTL ~where?

[sp1974]

nope didnt do it just showed rest of formulas on the sheet

[sp1974]

also if I click on the = button to see the formaula wizard or what ever it is the correct result is shown there but for whatever reason it is displaying the formula in the sheet itself

[deemo]

The cell is probably defined as "text" or somesuch. Do Control-1, then change the category to "general"

[sp1974]

weird but that seemed to do the trick but the weird part was after I changed it didnt change the result displayed but I had to retype the formula. Thanks