Prev: Different First Page?
Next: How do you turn on "view side by side"?
From: Dave Shultz on 5 Mar 2010 15:41
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?
From: Dave Peterson on 5 Mar 2010 16:03
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
From: Mike H on 5 Mar 2010 16:10
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.


"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?
 | 
Pages: 1
Prev: Different First Page?
Next: How do you turn on "view side by side"?