Vlookup will not retrun value

[Dave Shultz]

I have a very simple formula

=VLOOKUP(M3,Days!$A$5:$I$28,9,FALSE)

When I change M3 to N3 and hit enter, I see
=VLOOKUP(N3,Days!$A$5:$I$28,9,FALSE) displayed. How do I get this to retun
the value and not the text string?

 

[Dave Peterson]

Format the cell as General (or anything but text).
Then hit F2, then enter (excel will see that it's a formula)

 

[Mike H]

Hi,

Maybe the cell is formatted as text. Select the cell format as general then
tap F2 and ENTER
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.