Why doesn't "Replace" function find value I know exists?

  • Thread starter Thread starter UHAAdminAsst
  • Start date Start date
U

UHAAdminAsst

Using Excel 2003, I normally have no problem with the "REPLACE" function,
i.e. replacing year 2009 with 2010; however when I try to replace a value,
i.e. 1000.00 with 2000.00, even though I know 1000.00 is entered many times
in the worksheet, it cannot find it. I use the Format option and select "Use
Format From Cell" and it still does not work. What am I doing wrong? Thanks.
 
Hi,
are you importing the values?, sometimes there are blank spaces that you
cannot see, assuming numbers are in column B in another column enter

=trim(B1)

copy formula down and then use this column and overwrite the one with the
values

hope this helps
 
Is the value 1000.00 really that?

What do you see in the formula bar?

Might be 1000.00 is actually 1000.0000012 or similar.


Gord Dibben MS Excel MVP
 
Back
Top