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

Dave Shultz wrote:

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