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

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.
 
E

Eduardo

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number Format 1
using find and replace it's making me look in another file to upd 1
function MATCH returns wrong value 1
Find & Replace: find part cell, replace whole cell 2
Find & Replace 1
Counting Occurrence of a Value within Cells 1
Replace Function 2
REPLACE FUNCTION_ change 3.000 to 3... 5

Top