Find Command

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.

In the dialogue box that opens when you select Ctrl-F select options and
change the look in box to values
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Mike H." wrote:

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.

In the Find dialog box then is a button for Options (these are not shown by
default)

Clicking on the Options button will expand the box to show the advanced
options.

One of these is Look in. By default formulas is selected. Change this to
Values and you will be able to find your formula resulting in a value 1500.
--
If this helps, please remember to click yes.


"Mike H." wrote:

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.

Forgot to say that you'll need to have format without the 1000 (,) separator.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Mike H." wrote:

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.

First of all, select all the cells in the range you want to search
(eg. select columns A to F). Then press F5 (GoTo) and click on Special
and then on Constants - the cells containing formulae will not now be
selected.

Then you can do CTRL-F to look for the number 1500 in those
highlighted cells.

Hope this helps.

Pete

On Mar 24, 6:42*pm, Mike H. wrote:
If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. *How can I find
1500? *And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? *Thanks.

How do you "format without the 1000 (,) separator"? I don't understand that
statement. I can't find an obvious number and I think it is because of the
comma. Please explain. Thanks.

"Russell Dawson" wrote:

Forgot to say that you'll need to have format without the 1000 (,) separator.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Mike H." wrote:

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.

Or suppose I wish to find the cells that contain a formula that results in
1500 but I don't know if it has a comma or not. Or I don't know if it is
1500 or -1500. Can I still find all these:
1500
1,500
-1500
-1,500
and cells that have formulas that result in all 4 of the above. I can't
seem to get it to work. Thanks.

"Russell Dawson" wrote:

Forgot to say that you'll need to have format without the 1000 (,) separator.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Mike H." wrote:

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.

Format cells - number - under where you see the decimal places selector
uncheck the 1000 separator (,) box
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Mike H." wrote:

How do you "format without the 1000 (,) separator"? I don't understand that
statement. I can't find an obvious number and I think it is because of the
comma. Please explain. Thanks.

"Russell Dawson" wrote:

Forgot to say that you'll need to have format without the 1000 (,) separator.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Mike H." wrote:

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.

I cannot get find to find the resultant value of a formula. I must be
missing something and nobody answered my question about what do you do if you
don't know the format of the cell or don't care (more likely). I could care
less about the format. I just want to locate number whether it is the result
of a formula or it is just a number, whether or not it has commas or not and
I could care less about the format of the cell. Is there not a way to do
this in 1 step?

"Russell Dawson" wrote:

Format cells - number - under where you see the decimal places selector
uncheck the 1000 separator (,) box
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Mike H." wrote:

How do you "format without the 1000 (,) separator"? I don't understand that
statement. I can't find an obvious number and I think it is because of the
comma. Please explain. Thanks.

"Russell Dawson" wrote:

Forgot to say that you'll need to have format without the 1000 (,) separator.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Mike H." wrote:

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.