Thread: Find Command
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Find Command

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.