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.