A step easier.

Format the cell to General

F2 + ENTER to re-enter the formula.


Gord Dibben MS Excel MVP

On Wed, 14 Jan 2009 15:39:01 -0800, Gary''s Student
wrote:

1. clear the cell
2. format the cell to General
3. re-enter the VLOOKUP formula