Find Command
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.
|