| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| How do you Find and Replace the word "and" but not the and in "han | Excel Discussion (Misc queries) | |||
| How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
Hybrid Mode
