View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default Greater Than Find/Replace

Hi,

You can use Advanced filter to extract all the values of a particular field
0.50, and then replace the Value with the Value you want.


Challa Prabhu

"JG14" wrote:

I'm trying to find all values within a range that are 0.50, when I enter
that information into the find field on Find/Replace, however, it doesn't
seem to recognize formulas, only text.

Is there anyway to find all the numbers 0.50, or enter a formula into the
find field, and then replace only those with a specific format?