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.
0
Utf
1/27/2010 4:59:02 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

4 Replies
843 Views

Similar Articles

[PageSpeed] 1

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.
0
Utf
1/27/2010 5:09:01 PM
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
<UHAAdminAsst@discussions.microsoft.com> 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.

0
Gord
1/27/2010 7:36:33 PM
Excel doesn't store the number as 1000.00.  It stores it as 1000.
--
David Biddulph

"UHAAdminAsst" <UHAAdminAsst@discussions.microsoft.com> wrote in message 
news:FABCDD90-100E-4275-A829-DFE02EBC1ECC@microsoft.com...
> 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. 


0
David
1/28/2010 8:19:46 AM
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.

0
Gord
1/28/2010 7:14:54 PM
Reply:

Similar Artilces: