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

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.

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

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

"UHAAdminAsst" wrote:

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.

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

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


On Wed, 27 Jan 2010 08:59:02 -0800, UHAAdminAsst
wrote:

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.

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

Excel doesn't store the number as 1000.00. It stores it as 1000.
--
David Biddulph

"UHAAdminAsst" wrote in message
...
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.

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

Good point David.

May have nothing at all to do with hidden decimals.


Gord


On Thu, 28 Jan 2010 08:19:46 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Excel doesn't store the number as 1000.00. It stores it as 1000.