Vlookup and text format

  • Thread starter Thread starter hooper
  • Start date Start date
H

hooper

If I have a cell formatted as TEXT and enter a Vlookup function, the cell
displays the Vlookup formula rather than the result.

If I try to reformat the cell to GENERAL the cell still displays the Vlookup
formula.

If I clear the cell, format it as GENERAL then re-enter the Vlookup it
displays the correct result.

Shouldn't I be able to change the format of the cell from TEXT to GENERAL
without having to re-enter the VLOOKUP function??
 
Yes you can.
You then have to "re-enter" the formula to, (for want of a better term),
register the change.
*HOWEVER* ... re-enter doesn't necessarily mean to retype the entire
formula.
Simply clicking in the formula bar and then hitting <Enter> will do the job
*after* you change the format to General.

A nice keyboard shortcut to do all this in one shot is:
Select the "bad" formula cell, then,
<Ctrl> <Shift> <~>, then
<F2> <Enter>
 
Back
Top